"Ditto" - A Shortcut to Copying the Cell Above

Here's a handy shortcut not a lot of people know about - if you want the current cell you have selected to have the same thing in it as the one directly above it, you can just press control and quotation marks:

Ctrl + "

Whatever is in the cell above it will automatically be copied to the current cell.

1 comment:

  1. This shortcut does not seem to work in the current version of Excel for Mac. Any suggestions?