Excel shortcuts

Shortcut Keys for Excel: The Ultimate Guide

If you're an Excel power user, you know that using shortcut keys can help you work more efficiently in Excel. In this ultimate guide to Excel shortcut keys, we'll show you more than 200 shortcut keys for Excel that will help you speed up your work and become more productive.

We've organized the shortcut keys by category to make it easy for you to find the ones you need. Just click on a category below to jump to that section.

General Shortcut Keys

  • Ctrl + N: Create a new workbook
  • Ctrl + O: Open a workbook
  • Ctrl + S: Save a workbook
  • Ctrl + W: Close a workbook
  • Ctrl + F: Open the Find dialog box
  • Ctrl + H: Open the Replace dialog box
  • Ctrl + P: Open the Print dialog box
  • F1: Open the Help dialog box
  • F11: Create a chart sheet
  • Alt + F8: Open the Macro dialog box
  • Ctrl + Break: Stop a running macro

Navigation Shortcut Keys

  • Ctrl + G: Open the Go To dialog box
  • Ctrl + Page Up: Move to the previous worksheet
  • Ctrl + Page Down: Move to the next worksheet
  • Ctrl + Tab: Move to the next open workbook
  • Ctrl + Shift + Tab: Move to the previous open workbook
  • Ctrl + Arrow keys: Move to the edge of the current data region
  • Shift + Arrow keys: Select a range of cells
  • Ctrl + Shift + Arrow keys: Select the current region
  • Home: Move to the beginning of the row
  • End: Move to the end of the row
  • Ctrl + Home: Move to the beginning of the worksheet
  • Ctrl + End: Move to the last used cell on the worksheet
  • Page Up: Move up one screen
  • Page Down: Move down one screen
  • Ctrl + Page Up: Move to the previous worksheet
  • Ctrl + Page Down: Move to the next worksheet
  • Ctrl + Tab: Move to the next open workbook
  • Ctrl + Shift + Tab: Move to the previous open workbook
  • F5: Open the Go To dialog box
  • Ctrl + F5: Restore the window size
  • Shift + F5: Open the Find and Replace dialog box
  • Ctrl + Down arrow: Move to the last used cell in the column
  • Ctrl + Up arrow: Move to the first used cell in the column
  • Ctrl + Right arrow: Move to the last used cell in the row
  • Ctrl + Left arrow: Move to the first used cell in the row
  • Ctrl + Home: Move to the beginning of the worksheet
  • Ctrl + End: Move to the last used cell on the worksheet
  • Ctrl + Page Up: Move to the previous worksheet
  • Ctrl + Page Down: Move to the next worksheet
  • Ctrl + Tab: Move to the next open workbook
  • Ctrl + Shift + Tab: Move to the previous open workbook
  • F5: Open the Go To dialog box
  • Ctrl + F5: Restore the window size
  • Shift + F5: Open the Find and Replace dialog box
  • Ctrl + Down arrow: Move to the last used cell in the column
  • Ctrl + Up arrow: Move to the first used cell in the column
  • Ctrl + Right arrow: Move to the last used cell in the row
  • Ctrl + Left arrow: Move to the first used cell in the row
  • Home: Move to the beginning of the row
  • End: Move to the end of the row
  • Shift + Home: Select from the current cell to the beginning of the row
  • Shift + End: Select from the current cell to the end of the row
  • Ctrl + Home: Move to the beginning of the worksheet
  • Ctrl + End: Move to the last used cell on the worksheet
  • Ctrl + Page Up: Move to the previous worksheet
  • Ctrl + Page Down: Move to the next worksheet
  • Ctrl + Tab: Move to the next open workbook
  • Ctrl + Shift + Tab: Move to the previous open workbook
  • F5: Open the Go To dialog box
  • Ctrl + F5: Restore the window size
  • Shift + F5: Open the Find and Replace dialog box
  • Ctrl + Down arrow: Move to the last used cell in the column
  • Ctrl + Up arrow: Move to the first used cell in the column
  • Ctrl + Right arrow: Move to the last used cell in the row
  • Ctrl + Left arrow: Move to the first used cell in the row
  • Ctrl + Home: Move to the beginning of the worksheet
  • Ctrl + End: Move to the last used cell on the worksheet
  • Ctrl + Page Up: Move to the previous worksheet
  • Ctrl + Page Down: Move to the next worksheet
  • Ctrl + Tab: Move to the next open workbook
  • Ctrl + Shift + Tab: Move to the previous open workbook
  • F5: Open the Go To dialog box
  • Ctrl + F5: Restore the window size
  • Shift + F5: Open the Find and Replace dialog box
  • Ctrl + Down arrow: Move to the last used cell in the column
  • Ctrl + Up arrow: Move to the first used cell in the column
  • Ctrl + Right arrow: Move to the last used cell in the row
  • Ctrl + Left arrow: Move to the first used cell in the row
  • Home: Move to the beginning of the row
  • End: Move to the end of the row
  • Shift + Home: Select from the current cell to the beginning of the row
  • Shift + End: Select from the current cell to the end of the row
  • Ctrl + Home: Move to the beginning of the worksheet
  • Ctrl + End: Move to the last used cell on the worksheet
  • Ctrl + Page Up: Move to the previous worksheet
  • Ctrl + Page Down: Move to the next worksheet
  • Ctrl + Tab: Move to the next open workbook
  • Ctrl + Shift + Tab: Move to the previous open workbook
  • F5: Open the Go To dialog box
  • Ctrl + F5: Restore the window size
  • Shift + F5: Open the Find and Replace dialog box</

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.