Question: how to copy and paste in excel without copying the 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“.