Question: how to copy and paste values not formulas in excel?
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“.