Copy and Paste Values, Instead of Formulas (8/20)



0

When you copy and paste a value you obtained using a formula to another Google sheet or a cell that is far away from the original cell, the value can change. This is because what you are copying is the formula, not the value itself. You can easily copy and paste a value by using the keyboard shortcut: CTRL+C / CTRL+ Shift +V. Another way to copy and paste values is right clicking on the cells where you have to paste the value and select 'Paste Special' from the menu that appears. This will open a sub-menu with different paste options. Select 'Paste values only' from these options. Now your value will automatically be pasted.


talkKs editorial
Use the comment section to suggest new list items for inclusion

Comments 0

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

Solve : Which Number is Smaller 0 or 1 ?

You are invited to the talkKs Reader Community

Join Now