How to Move in Excel Without a Mouse

How-to basics · Updated November 20, 2026

To move around Excel without a mouse, use the arrow keys to change cells, Ctrl+Arrow keys to jump across a block of data, Ctrl+G to go to a specific cell, and Ctrl+Page Up or Ctrl+Page Down to switch worksheets. These shortcuts work in Excel for Microsoft 365 on Windows; Mac keyboard equivalents and function-key variations are noted below.

What You’ll Need

  • A keyboard and an open Excel workbook. No add-ins or special settings are required.
  • If you use a compact keyboard or laptop, check whether its Fn key is needed to send Page Up, Page Down, or function-key commands.

Step-by-Step

  1. Put focus in the worksheet. Click a cell before setting aside the mouse, or press Esc to leave a cell’s edit mode and return to navigation. If you are already working in a cell, the arrow keys may move the text cursor inside its contents rather than move to another cell. Press Enter or Esc to finish or cancel editing, then navigate. If focus is in the ribbon or a side pane, press F6 to cycle through Excel’s main areas until the worksheet is active; on some keyboards, press Fn+F6. You can tell the worksheet has focus when a cell has the active-cell outline.
  2. Move one cell at a time. Press the Up, Down, Left, or Right Arrow key to move the active cell by one cell in that direction. The active cell is the cell Excel will use for typing, pasting, or other commands. To move across a row or column while entering data, press Tab to move right or Enter to move down. Use Shift+Tab or Shift+Enter to reverse direction. These keys move the selection; they do not scroll the worksheet by a fixed number of rows.
  3. Jump to the edge of nearby data. Press Ctrl+Right Arrow, for example, to move toward the right edge of the current block of adjacent filled cells. Ctrl+Left Arrow, Ctrl+Up Arrow, and Ctrl+Down Arrow work in the other directions. A block is an uninterrupted region of data: a blank cell can split it, so a jump may stop at a blank or land at the next filled region. If you start in a blank area, the jump can move to the next nonblank cell or to the worksheet boundary. Press the shortcut again if you need to continue farther.
  4. Go to the first cell or the end of the used area. Press Ctrl+Home to return to the start of the worksheet, usually cell A1. Press Ctrl+End to go to the last cell Excel considers used, which may be beyond the visible data if formatting or old entries remain there. These commands are useful for resetting your position, but Ctrl+End does not necessarily identify the last meaningful value in the workbook.
  5. Go directly to a known cell address. Press Ctrl+G to open the Go To dialog, type a reference such as D250, and press Enter. Excel selects that cell even if it is far from the current view. To go to a cell on another sheet, enter a sheet reference such as Budget!B12; if the sheet name contains spaces, put it in single quotation marks, as in ‘Monthly Summary’!B12. Press Esc if you opened the dialog by mistake. Go To is usually faster and more reliable than repeated arrow presses for a distant destination.
  6. Select a range while moving. Hold Shift while pressing an arrow key to extend the selection from the active cell. For example, Shift+Down Arrow adds the cell below to the selection. Ctrl+Shift+Right Arrow extends the selection toward the edge of the data region. The cell where you began remains the anchor of the selection, while the active edge moves. Press an arrow key without Shift to return to selecting just one cell. Be careful before typing: typing into a multi-cell selection replaces the contents of the active cell, not every selected cell.
  7. Switch between worksheets. Press Ctrl+Page Down to move to the next worksheet tab and Ctrl+Page Up to move to the previous one. The active cell position may be different on each sheet, so check the cell outline after switching. If your keyboard has no dedicated Page Up or Page Down keys, use its Fn layer to send those keys; the exact combination varies by device. On Mac, the same Control+Page Up/Down shortcuts are commonly available, but a compact keyboard may require Fn with the arrow keys to produce Page Up or Page Down. If the shortcut is intercepted or unavailable, use Ctrl+G and enter a sheet-and-cell reference instead.

Common Mistakes

Typing into the cell instead of navigating. When a cell is in edit mode, arrow keys move the insertion point within its text or formula. Press Enter to keep the edit or Esc to cancel it before using arrows for cell movement. A blinking text cursor inside the cell is a clue that you are editing.

Expecting Ctrl+Arrow to skip every blank. The shortcut navigates the edges of data regions, and blank cells affect where it stops. In a table with gaps, use Ctrl+G to enter the destination address, or make the jump in stages and inspect the selected cell.

Confusing movement with selection. An arrow key changes the active cell; Shift+Arrow expands a range. If a large range stays highlighted, press an arrow key without Shift to collapse it to one cell. Before typing or deleting, check the outline so you know whether one cell or a range is selected.

Assuming Ctrl+End means last populated cell. Excel can include cells with leftover formatting in its used area. If Ctrl+End lands too far away, use Ctrl+G to go to a known address, or inspect the sheet for formatting or content beyond the apparent data.

Pressing shortcuts while the wrong area has focus. If the ribbon, formula bar, or a dialog is active, an arrow may move between controls rather than worksheet cells. Press Esc to close or exit the current interaction, then use F6 to return focus to the worksheet if needed.

Tips

Learn a small group of shortcuts first: the four arrows for nearby cells, Ctrl+Arrow for data blocks, Ctrl+Home for the start, Ctrl+G for an exact destination, and Ctrl+Page Up/Down for sheet changes. Once these become familiar, you can navigate most worksheets without memorizing a long shortcut list.

Use Ctrl+G whenever you already know a cell address. For example, entering F500 takes you straight to that location without scrolling through hundreds of rows. You can also type a range such as B2:E20 in Go To to select it, rather than entering the address of each corner separately. This is especially helpful when the sheet is large or contains gaps.

When entering a list, use Tab to move across columns and Enter to move down rows. Excel generally starts the next entry at the next cell in the direction you last used. If you select a range before typing, Tab can move through the selected cells, which helps keep entries inside a planned block. Try the pattern on a small area first if the selection has an unusual shape.

Keep an eye on the Name Box, the small field to the left of the formula bar that displays the active cell reference. It provides a quick check of where you landed. You can also use the keyboard to reach Go To rather than the Name Box, so you do not have to locate or click the field.

On a Mac, key labels and behavior depend on the keyboard and Excel build. Try Control with the arrow keys for data-region navigation and Control+G for Go To; use Fn if your keyboard needs it to send a navigation key. On Windows, laptops may require Fn for F6 or Page Up/Page Down too. If a key combination behaves differently, use Go To as a dependable alternative for cell navigation.

Troubleshooting

The arrow keys scroll the sheet instead of changing cells: Scroll Lock may be on. Turn it off with the Scroll Lock key, if your keyboard has one. On some laptops, Scroll Lock is accessed through an Fn combination; the key label or your computer’s keyboard documentation can identify it. When Scroll Lock is active, the view can move while the selected cell stays in place.

Ctrl+Arrow stops unexpectedly: Look for blank cells, a gap in the data, or the edge of the worksheet. Press the same shortcut again to continue across another region, or use Ctrl+G and enter the exact cell reference. If you expected a single continuous block, check whether seemingly empty cells contain spaces or formulas returning an empty string.

Ctrl+G does not open Go To: First press Esc to close an active cell edit or another dialog, then try Ctrl+G again. If a laptop or operating system intercepts the shortcut, access the Go To command from Excel’s Find & Select controls on the Home tab using the keyboard, or use the Name Box: press F6 until it receives focus, type a cell reference, and press Enter. F6 may require Fn on some keyboards.

You cannot switch sheets: Confirm the workbook has more than one worksheet and that the worksheet, not a dialog or ribbon control, has focus. Try Ctrl+Page Down or Ctrl+Page Up again, using Fn if needed to produce the Page keys. If the desired sheet name is known, Ctrl+G with a reference such as Sales!A1 can take you there directly.

A shortcut produces a different result on Mac: Mac keyboards may map Page Up, Page Down, and function keys differently, and browser or system shortcuts can take precedence in Excel for the web. Use Fn where required, verify that Excel has focus, or navigate by address with Control+G. If using Excel for the web, a browser may capture some key combinations; use the in-app keyboard shortcuts help or Go To when that happens.

Frequently Asked Questions

What is the fastest way to move to a specific cell?

Press Ctrl+G, type the cell address, such as H120, and press Enter. This is usually quicker than stepping through many rows with arrow keys.

How do I move to the next worksheet without a mouse?

Press Ctrl+Page Down for the next sheet or Ctrl+Page Up for the previous sheet. If your keyboard lacks those keys, use its Fn layer to send Page Down or Page Up.

How do I move to the last cell containing data?

Ctrl+End moves to Excel’s last used cell, which may include cells with leftover formatting. If that is not the true end of your data, use Ctrl+Arrow from a cell inside the relevant block or go to a known address with Ctrl+G.

How can I select cells without a mouse?

Move to the starting cell, hold Shift, and press an arrow key to extend the selection. Use Ctrl+Shift+Arrow to extend toward the edge of a data region. Press an arrow without Shift to return to a single active cell.

Can I navigate Excel without a mouse on a Mac?

Yes. Arrow keys, Go To, and many other navigation shortcuts are available on Mac. Control+G commonly opens Go To; Fn may be needed for Page Up, Page Down, or function keys depending on the keyboard.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.