Office shortcuts

Excel Shortcuts

# Command Description
1 ALT + W + F + R Freeze panes above cursor
2 CTRL + R Duplicate the cell to the left
3 CTRL + D Duplicate the cell above
4 ALT + DOWN-ARROW Display a menu of items entered in column
5 SHIFT + SPACE Select entire row
6 CTRL + SPACE Select entire column
7 CTRL + SHIFT + PLUS Insert cells (row, column)
8 CTRL + MINUS Delete cells (row, column)
9 ALT + EQUALS Auto sum column
10 CTRL + PAGE-DOWN/UP Switch worksheet