Shortcuts

Copy Value From the Cell Above

Pinterest LinkedIn Tumblr
Copy Value From the Cell Above 1

Ctrl-Shift ” is used to copy the value from the cell above to the active cell below.
When we click Ctrl-Shift “ the cell value gets copied in the active cell. If there is any formula applied to the above cell, it copies only the values and not the formula. This shortcut only works for columns. You cannot copy the cell values horizontally.

Copy Value From the Cell Above 2
Copy Value From the Cell Above 3

Related Posts

Write A Comment