|
|
Keyxl.com is one of the largest resources for keyboard shortcuts. The collection includes shortcuts for all major operating environments like Windows, Mac, and Linux. You can easily search for shortcuts by the program name or by category.
If you're new here, you may want to subscribe to my RSS feed or get updates through email. Thanks for visiting!
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 |
Keyboard shortcuts are definitely great time savers. Here is a list of shortcuts for Windows, Word, Excel and Outlook for you to use. Of course, it wouldn’t be possible for an average person to remember all the shortcuts but then you wouldn’t need to. It would be enough if you remember the ones that you would use most frequently. I would suggest that you take a print out of these shortcuts and keep them handy.
Read the full story
