Training >> Browse Articles >> Applications


10 Excel Secrets Every Admin Should Know

AdminSecret and Richard Rinyai

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!

AdminSecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.

* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

romanico received the quiz result of "21-50% correct: Good effort", about 2 years ago.
tmiller received the quiz result of "Satisfactory", about 2 years ago.
new2admin gave a thumbs down to The Article "6 Ways Finding a Dream Job Is Like Finding Your Soul Mate", about 2 years ago.
kinsh1987 received the quiz result of "Legal Secretary ", about 2 years ago.
LoraJ commented on: "Lora Coats", about 2 years ago.