Excel shortcuts

Useful Shortcut Keys for Excel 2013

If you work with Excel on a daily basis, you know that there are certain tasks that you perform over and over again. Rather than reaching for the mouse every time you need to do something, why not use shortcut keys? Shortcut keys can help you work more efficiently and can even help prevent repetitive strain injuries (RSIs).

Here are some useful shortcut keys for Excel 2013:

  • Ctrl + N: Create a new workbook
  • Ctrl + O: Open an existing workbook
  • Ctrl + S: Save the active workbook
  • Ctrl + P: Print the active worksheet
  • F11: Create a chart of the data in the active worksheet
  • Alt + F8: Display the Macro dialog box
  • Ctrl + F: Display the Find dialog box
  • Ctrl + H: Display the Replace dialog box
  • Ctrl + G: Display the Go To dialog box
  • Ctrl + Arrow keys: Move one cell in any direction
  • 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
  • Tab: Move to the next cell
  • Shift + Tab: Move to the previous cell
  • Enter: Move down one cell
  • Shift + Enter: Move up one cell
  • Ctrl + Enter: Fill the selected cell with the current entry
  • Esc: Cancel an entry in the cell
  • Alt + Enter: Start a new line in the same cell
  • Ctrl + ;: Enter the current date
  • Ctrl + Shift + :: Enter the current time
  • Ctrl + ': Copy the value from the cell above
  • F2: Edit the active cell
  • F5: Display the Go To dialog box
  • F7: Display the Spelling dialog box
  • F12: Display the Save As dialog box
  • Shift + F2: Edit the comment in the active cell
  • Shift + F5: Display the Find and Replace dialog box
  • Ctrl + A: Select the entire worksheet
  • Ctrl + B: Bold the contents of the selected cells
  • Ctrl + I: Italicize the contents of the selected cells
  • Ctrl + U: Underline the contents of the selected cells
  • Ctrl + 5: Strikethrough the contents of the selected cells
  • Ctrl + 1: Display the Format Cells dialog box
  • Ctrl + 2: Bold the contents of the selected cells
  • Ctrl + 3: Italicize the contents of the selected cells
  • Ctrl + 4: Underline the contents of the selected cells
  • Ctrl + 6: Strikethrough the contents of the selected cells
  • Ctrl + 7: Display the Format Cells dialog box
  • Ctrl + 8: Apply or remove outline borders from the selected cells
  • Ctrl + 9: Hide the selected rows
  • Ctrl + 0: Hide the selected columns
  • Ctrl + Shift + !: Apply the Number format
  • Ctrl + Shift + $: Apply the Currency format
  • Ctrl + Shift + #: Apply the Date format
  • Ctrl + Shift + %: Apply the Percent format
  • Ctrl + Shift + ^: Apply the Exponential number format
  • Ctrl + Shift + &: Apply the Outline border to the selected cells
  • Ctrl + Shift + _: Remove the Outline border from the selected cells
  • Ctrl + Shift + *: Select the entire worksheet
  • Ctrl + Shift + -: Display the Delete dialog box
  • Ctrl + Shift + (: Unhide any hidden rows within the selection
  • Ctrl + Shift + ): Unhide any hidden columns within the selection
  • Ctrl + Shift + &: Apply or remove outline borders from the selected cells
  • Ctrl + Shift + ~: Apply the General number format
  • Ctrl + Shift + _: Remove the Outline border from the selected cells
  • Ctrl + Shift + +: Display the Insert dialog box
  • Ctrl + Shift + =: Apply the AutoSum function to the selected cells
  • Ctrl + Shift + -: Display the Delete dialog box
  • Ctrl + Shift + ;: Enter the current date
  • Ctrl + Shift + :: Enter the current time
  • Ctrl + Shift + ": Apply or remove the double-underline format
  • Ctrl + Shift + *: Select the entire worksheet
  • Ctrl + Shift + /: Apply the Outline border to the selected cells
  • Ctrl + Shift + \: Remove the Outline border from the selected cells
  • Ctrl + Shift + ': Copy the value from the cell above
  • Ctrl + Shift + Tab: Move to the previous worksheet
  • Ctrl + Shift + F6: Move to the next worksheet
  • Ctrl + Shift + Page Up: Move to the previous worksheet
  • Ctrl + Shift + Page Down: Move to the next worksheet
  • Ctrl + Shift + O: Select the entire worksheet
  • Ctrl + Shift + P: Print the active worksheet
  • Ctrl + Shift + E: Center the selected cells
  • Ctrl + Shift + R: Right-align the selected cells
  • Ctrl + Shift + L: Left-align the selected cells
  • Ctrl + Shift + J: Justify the selected cells
  • Ctrl + Shift + B: Apply or remove bold formatting
  • Ctrl + Shift + I: Apply or remove italic formatting
  • Ctrl + Shift + U: Apply or remove underline formatting
  • Ctrl + Shift + ~: Apply the General number format
  • Ctrl + Shift + !: Apply the Number format
  • Ctrl + Shift + @: Apply the Time format
  • Ctrl + Shift + #: Apply the Date format
  • Ctrl + Shift + $: Apply the Currency format
  • Ctrl + Shift + %: Apply the Percent format
  • Ctrl + Shift + ^: Apply the Exponential number format
  • Ctrl + Shift + &: Apply the Outline border to the selected cells
  • Ctrl + Shift + _: Remove the Outline border from the selected cells
  • Ctrl + Shift + +: Display the Insert dialog box
  • Ctrl + Shift

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.