Every year or so, I like to access what
my Current Favorite Excel Keyboard Shortcuts are. This changes
over time as I learn new tricks and incorporate them into my daily work with
Excel.
As an Advanced Excel User, I am sure you understand the benefits of Keyboard Shortcuts. They add speed, efficiency, relief from the stress of overusing the mouse, and they are Just Plain Cool!
So, in David Letterman-style, here are my current favorite (and highly recommended) Top Ten Excel Shortcuts in reverse order:
10. Shift + F3 (Pulls up your Insert Function – Handy!)
9. F5 (Brings up the Go TO dialogue box – Great for navigating to a named range)
8. Ctrl + F4 (Closes the Current Window – Quick and easy!)
7. Ctrl + P (Pulls up the Print Dialog Box – Gotta love it)
6. F12 (Brings up the Save As dialogue – Nice!)
5. Ctrl + Z (Undo Previous Action – Oldie, but a goodie)
4. Ctrl + H (Find and Replace – I use it often!)
3. Alt + = (Brings up the AutoSum – Beats going to the toolbar)
2. Ctrl + Home (Brings you to the Start of the Worksheet – It is always good to go home)
And My Current Number One Best Shortcut Is (Drum Roll and Cymbals, Please)...
1. F11 (Creates an Instant Chart – Always a crowd pleaser!)
There you have it! Try a few of them, and see how they can make your Excel life better!
As an Advanced Excel User, I am sure you understand the benefits of Keyboard Shortcuts. They add speed, efficiency, relief from the stress of overusing the mouse, and they are Just Plain Cool!
So, in David Letterman-style, here are my current favorite (and highly recommended) Top Ten Excel Shortcuts in reverse order:
10. Shift + F3 (Pulls up your Insert Function – Handy!)
9. F5 (Brings up the Go TO dialogue box – Great for navigating to a named range)
8. Ctrl + F4 (Closes the Current Window – Quick and easy!)
7. Ctrl + P (Pulls up the Print Dialog Box – Gotta love it)
6. F12 (Brings up the Save As dialogue – Nice!)
5. Ctrl + Z (Undo Previous Action – Oldie, but a goodie)
4. Ctrl + H (Find and Replace – I use it often!)
3. Alt + = (Brings up the AutoSum – Beats going to the toolbar)
2. Ctrl + Home (Brings you to the Start of the Worksheet – It is always good to go home)
And My Current Number One Best Shortcut Is (Drum Roll and Cymbals, Please)...
1. F11 (Creates an Instant Chart – Always a crowd pleaser!)
There you have it! Try a few of them, and see how they can make your Excel life better!
No comments:
Post a Comment