Excel shortcuts

19 Excel Shortcuts for Navigating Spreadsheets Faster

If you're like most people, you probably spend a lot of time working with spreadsheets. And if you're like most people, you probably wish you could navigate them a little bit faster. Well, wish no more! Here are 19 Excel shortcuts that will help you get around your spreadsheets faster and more efficiently:

  1. Ctrl + Arrow Keys - Use the Ctrl key in conjunction with the arrow keys to quickly move to the edge of the current data region in your spreadsheet. For example, if you're currently in the middle of a column of data, pressing Ctrl + the left arrow key will take you to the beginning of that column. Pressing Ctrl + the right arrow key will take you to the end of the column. You can also use Ctrl + the up and down arrow keys to move to the beginning and end of rows.
  2. Shift + Arrow Keys - Use the Shift key in conjunction with the arrow keys to quickly select a range of cells. For example, if you want to select a column of data, you can press Shift + the left or right arrow key. If you want to select a row of data, you can press Shift + the up or down arrow key.
  3. Ctrl + Shift + Arrow Keys - Use the Ctrl and Shift keys together with the arrow keys to quickly select an entire column or row of data. For example, if you want to select an entire column, you can press Ctrl + Shift + the left or right arrow key. If you want to select an entire row, you can press Ctrl + Shift + the up or down arrow key.
  4. Home Key - The Home key will take you to the beginning of the current row. So if you're currently in the middle of a row, pressing the Home key will take you to the beginning of that row.
  5. End Key - The End key will take you to the end of the current row. So if you're currently in the middle of a row, pressing the End key will take you to the end of that row.
  6. Ctrl + Home - Use the Ctrl key in conjunction with the Home key to quickly go to the beginning of the spreadsheet. This shortcut is especially useful if you have a large spreadsheet that spans multiple pages.
  7. Ctrl + End - Use the Ctrl key in conjunction with the End key to quickly go to the end of the spreadsheet. This shortcut is especially useful if you have a large spreadsheet that spans multiple pages.
  8. Page Up/Page Down Keys - The Page Up and Page Down keys can be used to quickly scroll through your spreadsheet. The Page Up key will scroll up one page, while the Page Down key will scroll down one page.
  9. Ctrl + Page Up/Page Down Keys - Use the Ctrl key in conjunction with the Page Up and Page Down keys to quickly go to the beginning or end of the current column. For example, if you're currently in the middle of a column, pressing Ctrl + Page Up will take you to the beginning of that column, while pressing Ctrl + Page Down will take you to the end of that column.
  10. Alt + Page Up/Page Down Keys - Use the Alt key in conjunction with the Page Up and Page Down keys to quickly go to the beginning or end of the current row. For example, if you're currently in the middle of a row, pressing Alt + Page Up will take you to the beginning of that row, while pressing Alt + Page Down will take you to the end of that row.
  11. Ctrl + Tab - Use the Ctrl key in conjunction with the Tab key to quickly switch between open Excel workbooks. This shortcut is especially useful if you have multiple workbooks open at the same time.
  12. Ctrl + Shift + Tab - Use the Ctrl and Shift keys together with the Tab key to quickly switch between open Excel workbooks in the reverse order. This shortcut is especially useful if you have multiple workbooks open at the same time.
  13. Ctrl + F - Use the Ctrl key in conjunction with the F key to open the Find dialog box. This dialog box can be used to search for specific text within your spreadsheet.
  14. Ctrl + H - Use the Ctrl key in conjunction with the H key to open the Replace dialog box. This dialog box can be used to search for and replace specific text within your spreadsheet.
  15. Ctrl + G - Use the Ctrl key in conjunction with the G key to open the Go To dialog box. This dialog box can be used to quickly go to a specific cell or range of cells within your spreadsheet.
  16. F5 - The F5 key can be used to open the Go To dialog box. This dialog box can be used to quickly go to a specific cell or range of cells within your spreadsheet.
  17. Ctrl + A - Use the Ctrl key in conjunction with the A key to quickly select the entire spreadsheet. This shortcut is especially useful if you want to apply formatting to an entire sheet of data.
  18. Ctrl + P - Use the Ctrl key in conjunction with the P key to open the Print dialog box. This dialog box can be used to print your spreadsheet.
  19. Ctrl + S - Use the Ctrl key in conjunction with the S key to save your spreadsheet. This shortcut is especially useful if you want to save your work quickly.
  20. Ctrl + Z - Use the Ctrl key in conjunction with the Z key to undo the last action you performed. This shortcut is especially useful if you accidentally delete or modify a cell.
  21. Ctrl + Y - Use the Ctrl key in conjunction with the Y key to redo the last action you performed. This shortcut is especially useful if you accidentally undo an action you didn't mean to.
  22. Ctrl + 1 - Use the Ctrl key in conjunction with the 1 key to open the Format Cells dialog box. This dialog box can be used to format cells and ranges of cells within your spreadsheet.
  23. Ctrl + 2 - Use the Ctrl key in conjunction with the 2 key to bold the selected text. This shortcut is especially useful for quickly formatting text.
  24. Ctrl + 3 - Use the Ctrl key in conjunction with the 3 key to italicize the selected text. This shortcut is especially useful for quickly formatting text.
  25. Ctrl + 4 - Use the Ctrl key in conjunction with the 4 key to underline the selected text. This shortcut is especially useful for quickly formatting text.
  26. Ctrl + 5 - Use the Ctrl key in conjunction with the 5 key to strikethrough the selected text. This shortcut is especially useful for quickly formatting text.

By using these shortcuts, you can quickly navigate your way around Excel spreadsheets and get your work done faster. So next time you're working with a spreadsheet, try out some of these shortcuts and see how much time you can save!

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.