"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.

Categories: Excel, Excel shortcuts, keyboard shortcuts, Microsoft Office 2007, shortcuts