Using keyboard shortcuts is a much more efficient way of working than choosing options through the menu. Here are a few killer keyboard shortcuts for Microsoft Excel that can save you time.
| Action | Shortcut |
| Apply the outline border to the selected cells | Ctrl+Shift+& |
| Apply the Date format with the day, month, and year | Ctrl+Shift+# |
| Apply the Time format with the hour and minute, and AM or PM | Ctrl+Shift+@ |
| Enter the current time | Ctrl+Shift+: |
| Enter the current date | Ctrl+; |
| Hide the selected columns | Ctrl+0 (zero) |
| Alternate between displaying cell values and displaying formulas in the worksheet | Ctrl+’ |
| Display the Find and Replace dialog box, with the Replace tab selected | Ctrl+H |
| Display the Print Preview window | Ctrl+F2 |
| Switch to the next workbook window | Ctrl+F6 |
| Display the Macro dialog box to create, run, edit, or delete a macro | Alt+F8 |
You May Also Be Interested In...
- Get things done fast with keyboard shortcuts for Windows, Word, Excel and Outlook
- Some Firefox shortcuts to speed up your browsing
- Time-saving shortcuts in Windows Explorer
- Shortcuts for quick access to Control Panel applets
- Simple Firefox trick to autocomplete web addresses
- Insert your signature using Autocorrect in Word
- Timesaving shortcuts to Open Windows XP Applications and Utilities
- Few Excel Tips to make you more productive
Subscribe Now
If you enjoyed this post, you will definitely enjoy our others. Subscribe to the feed to get future posts delivered right to your mailbox or feedreader.
Powered by Thesis
An amazing WordPress Theme, nothing beats the versatility and SEO friendliness of the Thesis framework.
From beginners, to the most advanced WordPress developers, Thesis makes it easy for anyone to customize it.
{ 3 comments… read them below or add one }
Grazie per la segnalazione molto interessante
una domandona, ma se io volessi modificare le combinazioni a mio piacimento, come si fa??
grazie ciao.
Is this gonna end someday??
fantastic tool u derived dear keep it up thanks a lot