Question: how to copy and paste formula values in excel?
Answer: Press CTRL+SHIFT+ the down arrow key to select the column. Click the Copy button from the Home tab on the ribbon. Click the bottom part of the Paste button on the toolbar, and then select the Paste Values button.