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 |
Social