Don\'t Miss
Home / Tips & Tricks / MS Office Tricks / A few killer keyboard shortcuts for Excel

A few killer keyboard shortcuts for Excel

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

Previous:

Next:

comments powered by Disqus
Scroll To Top