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.
Comments 0