How to Paste Values Without Formulas in Excel

When you copy and paste cells “the normal way” (Ctrl + c –> Ctrl + v), formulas and formatting is pasted as well. But in many cases, you want to “freeze” the values, so that they can’t be changed any more. In this article we learn how to copy and paste values only in two ways.

Steps for pasting values with the mouse

To paste cell values but not the underlying formulas, follow these steps (the numbers are corresponding to the image on the right side):

paste, values, paste special, formulas, excel, How to Paste Values Only
  1. Select the cells which you want to remove the formulas from and copy them. Therefore, click on Copy (hidden under number 3 in above picture). 
  2. Select the cells which you want to paste your copied cells. This can also be the source range if you want to overwrite your original calculations. 
  3. Paste the copied cells by pressing clicking on the large paste button and then on ‘Paste Special’.
  4. Click on “Values”. 
  5. Click “OK”

Now, all formulas are replaced by values.

Paste values only with keyboard shortcuts

After we got to know how to paste values only with the mouse, we take it a step further. Now we learn how to paste values with keyboard shortcuts only – no mouse needed. The reason is, that keyboard shortcuts are usually much faster. 

The steps are basically the same, except that we replace each click with keys to press on the keyboard:

  1. Select the cells which you want to remove the formulas from by pressing Shift on the keyboard and navigating with the arrow keys. Keep shift pressed. When are done selecting the cell range press “Ctrl + c” for copying them. 
  2. Select the cells which you want to paste your copied cells. 
  3. Paste the copied cells by pressing Paste Special (“Ctrl + Alt + v”). 
  4. Select “Values” by pressing v.
  5. Press Enter on the keyboard.

Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

1 comment

  1. dear sir,

    i want a small favour from you i want one excel sheet with vba satisfying below conditions
    1. in column A1 to A100, the values keeping changing for everysecond (this I will get from my API’s)
    i needhelp from you is for below.,
    2. i want to paste values for every 10 seconds in different columns, say 5 seconds in column B, after 10 seconds in Column C …. so on.

    please help out

Leave a comment

Your email address will not be published. Required fields are marked *