Excel shortcuts

Excel Keyboard Shortcuts: The Complete Guide

If you're like most people, you probably use a handful of keyboard shortcuts in Excel on a daily basis. But did you know that there are hundreds of shortcuts that can save you time and make you more productive? In this comprehensive guide, we'll show you all the Excel keyboard shortcuts you need to know.

First, let's start with the basics. If you're new to using keyboard shortcuts, you can use the following keys on your keyboard to perform common tasks:

  • Ctrl: Used in conjunction with another key to perform a specific task. For example, Ctrl + C copies text or a cell in Excel.
  • Alt: Used in conjunction with another key to perform a specific task. For example, Alt + F opens the File menu in Excel.
  • Shift: Used to select a range of cells or text. For example, Shift + click selects multiple cells in Excel.
  • Tab: Moves to the next cell in a row or column. For example, if you're in cell A1 and you press Tab, you'll move to cell B1.
  • Enter: Moves to the next cell in a row or column. For example, if you're in cell A1 and you press Enter, you'll move to cell A2.
  • Home: Moves to the beginning of a row or column. For example, if you're in cell A1 and you press Home, you'll move to cell A1.
  • End: Moves to the end of a row or column. For example, if you're in cell A1 and you press End, you'll move to cell A1.
  • Page Up: Moves up one screen. For example, if you're in cell A1 and you press Page Up, you'll move to cell A1.
  • Page Down: Moves down one screen. For example, if you're in cell A1 and you press Page Down, you'll move to cell A1.
  • Esc: Cancels an action. For example, if you're in the middle of typing a formula and you press Esc, you'll cancel the formula.
  • F1: Opens the Help window. For example, if you press F1 while you're in Excel, the Help window will open.
  • F2: Edits the active cell. For example, if you're in cell A1 and you press F2, you'll be able to edit the contents of cell A1.
  • F4: Repeats the last action. For example, if you press F4 after copying a cell, you'll paste the copied cell.
  • F5: Refreshes the current sheet. For example, if you make changes to a sheet and then press F5, the changes will be applied to the sheet.
  • F7: Checks the spelling of the active sheet. For example, if you press F7 while you're in Excel, the spelling checker will run and highlight any errors.
  • F11: Creates a chart of the active data. For example, if you have a data set in Excel and you press F11, a chart will be created based on the data set.
  • F12: Opens the Save As dialog box. For example, if you press F12 while you're in Excel, the Save As dialog box will open so you can save your workbook.

Now that you know the basics, let's take a look at some of the more advanced shortcuts that you can use in Excel.

To insert a new row:

  1. Place your cursor on the row where you want to insert the new row.
  2. Press Ctrl + Shift + + (plus sign).

To insert a new column:

  1. Place your cursor on the column where you want to insert the new column.
  2. Press Ctrl + Shift + + (plus sign).

To delete a row:

  1. Place your cursor on the row that you want to delete.
  2. Press Ctrl + - (minus sign).

To delete a column:

  1. Place your cursor on the column that you want to delete.
  2. Press Ctrl + - (minus sign).

To hide a row:

  1. Select the rows that you want to hide.
  2. Press Ctrl + 9.

To hide a column:

  1. Select the columns that you want to hide.
  2. Press Ctrl + 0 (zero).

To unhide a row:

  1. Select the rows that you want to unhide.
  2. Press Ctrl + Shift + 9.

To unhide a column:

  1. Select the columns that you want to unhide.
  2. Press Ctrl + Shift + 0 (zero).

To filter a data set:

  1. Select the data set that you want to filter.
  2. Press Ctrl + Shift + L.

To sort a data set:

  1. Select the data set that you want to sort.
  2. Press Ctrl + Shift + S.

To apply conditional formatting:

  1. Select the data set that you want to apply conditional formatting to.
  2. Press Ctrl + Shift + L.

To insert a hyperlink:

  1. Select the cell where you want to insert the hyperlink.
  2. Press Ctrl + K.

To insert a comment:

  1. Select the cell where you want to insert the comment.
  2. Press Ctrl + Shift + M.

To insert a picture:

  1. Select the cell where you want to insert the picture.
  2. Press Ctrl + Shift + G.

To insert a symbol:

  1. Select the cell where you want to insert the symbol.
  2. Press Ctrl + Shift + U.

To insert a line break:

  1. Select the cell where you want to insert the line break.
  2. Press Ctrl + Shift + Return.

To insert a page break:

  1. Select the cell where you want to insert the page break.
  2. Press Ctrl + Shift + Return.

To insert a column break:

  1. Select the cell where you want to insert the column break.
  2. Press Ctrl + Shift + Return.

To insert a row break:

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.