Notice that in column G the cells are colored purple, are bold, and are centered. In this scenario, let's say that we want to paste only the values from the 'Total' column into a different column, without the formulas being transferred. The data below shows the same list of clothing items from the last example, but this time there are two lists that show quantity, and there is also a column that has formulas which add/total the two 'Quantity' columns. When there are formulas in your sheet and you want to copy and paste the values that they display instead of pasting the formulas themselves, then pasting values only is the perfect way to handle this. 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. 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.

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

How to copy and paste in word mobile