Question: how to copy and paste excel data with formula?
Answer: Select the cells or ranges you wish to copy. Select the “Home” tab. Select “Copy” in the “Clipboard section. Select the cell you wish to paste your values to. Select the lower half of the large “Paste” button. From the extended menu that appears, select “Values“. Select “OK“.