Question: how to copy and paste values without 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. ...  Select “OK“.