January 29, 2013

13 Killer Excel 2007 Shortcuts

Here are some great Excel 2007 shortcuts published by PCMagazine.com
  • 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

No comments:

Post a Comment