How to Navigate a Workbook in Excel

This guide walks you through the essential skills for moving around a large Excel workbook efficiently. You’ll learn how to jump between sheets, scroll through thousands of rows, select data ranges, and use keyboard shortcuts to save time. No prior Excel experience is needed, just a workbook open on your screen.

What You’ll Need

A computer with Microsoft Excel (2016 or later, or Microsoft 365) installed.
An Excel workbook (.xlsx or .xls) you want to practice with.
Basic familiarity with using a mouse or trackpad and a keyboard.

Step-by-Step

Open your workbook. Double-click the file in File Explorer (Windows) or Finder (Mac), or open Excel and go to File > Open to browse for it. Once open, you’ll see a grid of cells organized into columns (letters) and rows (numbers).
Move between worksheets. Look at the tabs at the bottom of the window. Click a tab to switch to that sheet. If you have many tabs, use the left and right arrow buttons next to the tabs to scroll through them, or right-click the arrow buttons to see a list of all sheets.
Navigate within a sheet using the mouse. Click any cell to select it. Use the vertical and horizontal scroll bars to move around. To zoom in or out, hold Ctrl (Windows) or Cmd (Mac) and scroll with your mouse wheel, or use the zoom slider in the bottom-right corner.
Use arrow keys and Enter. Press the arrow keys to move one cell in that direction. Press Enter to move down one cell, and Shift+Enter to move up. Tab moves right, Shift+Tab moves left.
Jump to the edge of data. Select a cell, then double-click any edge of the cell border (the thick outline). Excel will jump to the last non-empty cell in that direction. For example, double-click the bottom border to go to the last row with data in that column.
Use the Go To feature. Press Ctrl+G (Windows) or Cmd+G (Mac). A dialog box appears. Type a cell reference like Z500 and press Enter to jump directly to that cell. This is extremely useful for large datasets.
Use the Name Box. The Name Box is the small field to the left of the formula bar (above the column letters). Click it, type a cell reference (e.g., D15), and press Enter. You can also select a named range from the drop-down arrow.
Navigate with Ctrl+Arrow keys. Hold down Ctrl (Windows) or Cmd (Mac) and press an arrow key to jump to the edge of the current data region. For example, Ctrl+Down Arrow from the top of a column takes you to the last filled cell in that column.
Move between sheets with the keyboard. Press Ctrl+Page Down (Windows) or Cmd+Page Down (Mac) to go to the next sheet. Press Ctrl+Page Up (or Cmd+Page Up) to go to the previous sheet.
Select large ranges. Click the first cell, then hold Shift and click the last cell to select everything in between. Or, click the first cell, press Ctrl+Shift+Arrow Key (Windows) or Cmd+Shift+Arrow Key (Mac) to select to the edge of the data. To select the entire sheet, click the triangle at the intersection of the row numbers and column letters, or press Ctrl+A (Windows) / Cmd+A (Mac) twice.
Use the Find feature. Press Ctrl+F (Windows) or Cmd+F (Mac). Type a value or text you’re looking for, and press Enter. Excel will highlight the first match. Use the Find Next button to cycle through matches. This is the fastest way to locate a specific entry in a large workbook.
Freeze panes for easy scrolling. If you have header rows or columns you want to keep visible while scrolling, go to the View tab, click Freeze Panes, and choose Freeze Top Row or Freeze First Column. To freeze both, select the cell below and to the right of the headers, then choose Freeze Panes.

Common Mistakes

Scrolling with the mouse wheel only. This moves the view but not the active cell. To move the active cell, you must click or use arrow keys. Many users get lost because they scroll but don’t realize the selection hasn’t moved.
Using Ctrl+Arrow keys on empty cells. If there are gaps in your data, Ctrl+Arrow will jump to the next empty cell, not the end of your dataset. This can be confusing. Use it only when your data is contiguous.
Forgetting to save after rearranging. If you move or hide sheets, remember to save (Ctrl+S / Cmd+S) to keep your changes.
Misunderstanding sheet tabs. Clicking a tab selects the sheet, but double-clicking it enters edit mode for the tab name. If you accidentally rename a tab, press Esc to cancel.

Tips

Use the Ctrl+Home (Windows) or Cmd+Home (Mac) shortcut to jump to cell A1 of the current sheet.
Press Ctrl+End (Windows) or Cmd+End (Mac) to go to the last used cell in the sheet (the intersection of the last row and column with data).
Create named ranges for important cells (e.g., “Total”) so you can jump to them quickly from the Name Box.
If you work with multiple sheets, color the tabs (right-click tab > Tab Color) to visually distinguish them.
Use the Zoom feature (bottom-right slider) to see more or fewer cells at once. This helps when navigating large areas.
For very large workbooks, consider using the Go To Special (Ctrl+G, then Special) to find blank cells, formulas, or constants.

Troubleshooting

Arrow keys don’t move cells. This usually happens when Scroll Lock is on. Look for a “Scroll Lock” indicator on your keyboard (often an LED). Press the Scroll Lock key to turn it off. On some laptops, you may need to press Fn+Scroll Lock or Fn+S.
Can’t find a sheet tab. If the tabs are hidden, go to File > Options (Excel Options on Mac), then Advanced. Under “Display options for this workbook,” check the box for “Show sheet tabs.” Also, ensure the horizontal scrollbar isn’t covering them—drag it to the right.
Ctrl+Arrow jumps too far or not far enough. Check if your data has blank rows or columns. If so, either fill them or use the Go To feature (Ctrl+G) to type a specific cell reference.
Freeze Panes doesn’t work as expected. If you freeze the top row, it only freezes that row. To freeze multiple rows, select the cell in the first column that is just below the rows you want to freeze, then click Freeze Panes. For example, to freeze rows 1-3, select cell A4 and then Freeze Panes.
Find doesn’t locate a value. Make sure you’re searching the correct sheet. The Find feature searches only the current sheet by default. To search the entire workbook, click Options in the Find dialog and choose “Workbook” under “Within.”

Frequently Asked Questions

Q: What is the fastest way to go to the last row of data?
A: Click any cell in the column you want, then press Ctrl+Down Arrow (Windows) or Cmd+Down Arrow (Mac). If there are no blank cells in that column, you’ll jump to the last filled row.

Q: How do I switch between sheets without a mouse?
A: Use Ctrl+Page Down (Windows) or Cmd+Page Down (Mac) to go to the next sheet, and Ctrl+Page Up (Windows) or Cmd+Page Up (Mac) to go to the previous one.

Q: Why does my arrow key move the whole sheet instead of the cell?
A: That’s Scroll Lock. Turn it off by pressing the Scroll Lock key (or Fn+Scroll Lock on some laptops). The status bar at the bottom may show “Scroll Lock” when it’s on.

Q: Can I jump to a specific cell in another sheet?
A: Yes. Press Ctrl+G (Windows) or Cmd+G (Mac), type the sheet name followed by an exclamation mark and the cell reference, like Sheet2!B10, then press Enter. Excel will take you there.

Q: How do I quickly select all data in a sheet?
A: Click the first cell (e.g., A1), then press Ctrl+Shift+End (Windows) or Cmd+Shift+End (Mac). This selects from the current cell to the last used cell. Alternatively, press Ctrl+A (Windows) or Cmd+A (Mac) once to select the current data region, and twice to select the entire sheet.

Q: What does the Name Box do for navigation?
A: The Name Box (left of formula bar) lets you type a cell reference and press Enter to jump to it. It also lists named ranges, so you can click a name to go to that area instantly.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →