Mar 13 2009

Excel Shortcuts

Category: Tips and Tricksadmin @ 10:10 am
  • 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 ]
  • Share This Post

    No related posts.

    Related posts brought to you by Yet Another Related Posts Plugin.

    Leave a Reply

    You must be logged in to post a comment.