![is there a keyboard shortcut for paste values only is there a keyboard shortcut for paste values only](https://www.howtoexcel.org/wp-content/uploads/2020/12/Paste-Special-Keyboard-Shortcut.png)
Now that you see how pasting values only will not change formatting… let's see how you can use the same method to copy and paste the values that formulas display, without pasting the formula itself.
#Is there a keyboard shortcut for paste values only how to
How to copy and paste values, not formulas Paste values only by pressing Ctrl + Shift + V on the keyboard.Copy the selection by pressing Ctrl + C on the keyboard.To copy and paste the values from column G into column E as shown in the example below, do the following: When using "paste values only" to paste into this location, only the values will be pasted/updated, and the formatting of the destination will remain the same. Notice that in column E the cells are colored purple, are bold, and are centered. In this scenario, let's say that we have an updated quantity list, and that we want to copy and paste the new quantities over the original values, without changing the formatting. The data below shows a list of clothing items that are in inventory, and the quantity of each item. Later I will show you how the same process also works when you are using formulas, but for now let's stick to pasting without affecting formatting.
![is there a keyboard shortcut for paste values only is there a keyboard shortcut for paste values only](https://i.ytimg.com/vi/jd9PZd7Itzs/maxresdefault.jpg)
In this first example we will copy and paste values in a Google Spreadsheet without changing the formatting of the cells. How to copy and paste values without formatting