Print

Hired 101 >> Browse Articles >> Preparation & Appearance

+9

10 Excel Secrets Everyone Should Know

SalesHQ and Richard Rinyai

August 18, 2009

10. Shortcuts, Shortcuts, Shortcuts

One way to really lessen the time you spend in Excel is to learn the shortcuts. In these cases, the + symbol indicates that the two keys should be typed together, not that you should add in that symbol.

Moving within a sheet without your mouse:
tab moves right
tab+shift moves left
enter moves down
enter+shift moves up

To display print menu: Ctrl+P

To save: Ctrl+S

To create a new worksheet: Ctrl+N or Alt+Shift+F1

Undo: Ctrl+Z
Redo: Ctrl+Y
Cut: Ctrl+X
Copy: Ctrl+C
Paste: Ctrl+V

Font Options:
Ctrl+2 Bold
Ctrl+3 Italic
Ctrl+4 Underline
Ctrl+5 Strikethrough
Shift+Ctrl+F Font Drop Down List

Ctrl+9 Hide rows
Ctrl+0 Hide columns
Ctrl+Shift+( Unhide rows
Ctrl+Shift+) Unhide columns

What are your favorite Excel tips? Share below!