Excel shortcuts

15 Keyboard Shortcuts for Navigating Excel Spreadsheets

If you're an Excel power user, you know that using the mouse to click around a spreadsheet can be a real pain. That's why we've compiled a list of our favorite keyboard shortcuts for navigating Excel spreadsheets. With these shortcuts, you'll be able to move around your spreadsheet with ease, and get your work done faster.

1. Ctrl + Arrow Keys - Use the Ctrl key in conjunction with the arrow keys to 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 + Left Arrow will take you to the beginning of that column. You can also use Ctrl + Right Arrow, Ctrl + Up Arrow, and Ctrl + Down Arrow to move to the right edge of the current data region, the top of the current data region, and the bottom of the current data region, respectively.

2. Shift + Arrow Keys - Use the Shift key in conjunction with the arrow keys to select a range of cells. For example, if you want to select a column of data, you can press Shift + Left Arrow to select the cells to the left of the cell you're currently in. You can also use Shift + Right Arrow, Shift + Up Arrow, and Shift + Down Arrow to select the cells to the right of the cell you're currently in, the cells above the cell you're currently in, and the cells below the cell you're currently in, respectively.

3. Home - Pressing the Home key will take you to the beginning of the current row. So, if you're currently in cell D5, pressing Home will take you to cell A5.

4. End - Pressing the End key will take you to the end of the current row. So, if you're currently in cell D5, pressing End will take you to cell Z5.

5. Ctrl + Home - Pressing Ctrl + Home will take you to the very first cell in your spreadsheet, which is cell A1.

6. Ctrl + End - Pressing Ctrl + End will take you to the very last cell in your spreadsheet that contains data. So, if your spreadsheet contains data in cells A1 through Z100, pressing Ctrl + End will take you to cell Z100.

7. Page Up - Pressing the Page Up key will move you up one screen in your spreadsheet. So, if you're currently viewing cells A1 through A20, pressing Page Up will cause cells A1 through A20 to move off the screen, and cells A21 through A40 to be displayed.

8. Page Down - Pressing the Page Down key will move you down one screen in your spreadsheet. So, if you're currently viewing cells A21 through A40, pressing Page Down will cause cells A21 through A40 to move off the screen, and cells A1 through A20 to be displayed.

9. Ctrl + Page Up - Pressing Ctrl + Page Up will move you up one full screen in your spreadsheet. So, if your spreadsheet is currently displayed in Page Layout view, pressing Ctrl + Page Up will cause the current page to move off the screen, and the previous page to be displayed.

10. Ctrl + Page Down - Pressing Ctrl + Page Down will move you down one full screen in your spreadsheet. So, if your spreadsheet is currently displayed in Page Layout view, pressing Ctrl + Page Down will cause the current page to move off the screen, and the next page to be displayed.

11. Alt + Page Up - Pressing Alt + Page Up will move you up one full screen in your spreadsheet, just like Ctrl + Page Up. However, unlike Ctrl + Page Up, which moves you up one page at a time, Alt + Page Up will move you up one screen at a time. So, if you're currently viewing cells A1 through A20, pressing Alt + Page Up will cause cells A1 through A10 to move off the screen, and cells A11 through A30 to be displayed.

12. Alt + Page Down - Pressing Alt + Page Down will move you down one full screen in your spreadsheet, just like Ctrl + Page Down. However, unlike Ctrl + Page Down, which moves you down one page at a time, Alt + Page Down will move you down one screen at a time. So, if you're currently viewing cells A11 through A30, pressing Alt + Page Down will cause cells A11 through A20 to move off the screen, and cells A21 through A40 to be displayed.

13. Ctrl + Mouse Wheel - If you have a mouse with a scroll wheel, you can use the Ctrl key in conjunction with the scroll wheel to zoom in and out of your spreadsheet. Simply hold down the Ctrl key and scroll the mouse wheel up to zoom in, or scroll the mouse wheel down to zoom out.

14. F5 - Pressing the F5 key will bring up the Go To dialog box, which allows you to quickly jump to a specific cell in your spreadsheet. Simply enter the cell address that you want to go to in the dialog box, and press Enter.

15. Ctrl + F5 - Pressing Ctrl + F5 will restore your spreadsheet to its original size. So, if you've zoomed in on your spreadsheet using the Ctrl + Mouse Wheel shortcut, pressing Ctrl + F5 will zoom you back out.

We hope you find these keyboard shortcuts helpful! If you have any questions, or if you know of any other helpful shortcuts, feel free to leave a comment below.

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.