![]() 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |