- 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 rows - Ctrl-9
- Hide the selected columns - Ctrl-0
- 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 Insert Hyperlink dialog box for new hyperlink - Ctrl-K
- 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
January 29, 2013
13 Killer Excel 2007 Shortcuts
Here are some great Excel 2007 shortcuts published by PCMagazine.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment