Jump to content
Sign in to follow this  
kyros

Microsoft Excel Shortcut Keys

Recommended Posts

  • F2: Edit the active cell.
  • F5: Displays the Go To box.
  • F7: Open the Spelling dialogue box to check a selected range.
  • F11: Create a chart of data in the current range in a separate sheet.
  • Alt + Shift + F1: Insert a new worksheet.
  • Shift + F3: Opens Insert Function dialogue box.
  • Shift + F5: Opens the Find and Replace dialogue box.
  • Ctrl + Shift + Colon (:): Enter the current time.
  • Ctrl + Semicolon (;): Enter the current date.
  • Ctrl + A: Select all content in the worksheet.
  • Ctrl + B: Bold highlighted selection.
  • Ctrl + I: Italicize highlighted selection.
  • Ctrl + K: Open the Insert hyperlink dialogue box.
  • Ctrl + U: Underline highlighted selection.
  • Ctrl + 5: Apply strikethrough formatting.
  • Ctrl + P: Brings up the print dialog box.
  • Ctrl + Z: Undo.
  • Ctrl + F9: Minimize a workbook window to an icon.
  • Ctrl + F10: Maximize a selected workbook window.
  • Ctrl + F6: Switch to the next workbook window when multiple are open.
  • Ctrl + Page Up: Move to previous sheet in a workbook.
  • Ctrl + Page Down: Move to next sheet in a workbook.
  • Ctrl + Tab: Switch to next tab in dialogue box.
  • Ctrl + Apostrophe ('): Insert the value of the above cell into the cell currently selected.
  • Ctrl + Shift + !: Apply the Number format.
  • Ctrl + Shift + $: Apply the Currency format.
  • Ctrl + Shift + #: Apply the Date format.
  • Ctrl + Shift + %: Apply the Percentage format.
  • Ctrl + Shift + ^: Apply the Exponential format.
  • Ctrl + Shift + @: Apply the Time format.
  • Ctrl + Arrow Key: Move to the edge of the current data region in a worksheet.
  • Ctrl + Space: Select an entire column in a worksheet.
  • Shift + Space: Select an entire row in a worksheet.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

This page uses cookies to confirm that you will have the best user experience. More Privacy Policy