Print

Training >> Browse Articles >> Applications

+50

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

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