How to Select Cells in Excel With Keyboard Shortcuts

How-to basics · Updated November 20, 2026

To select cells in Excel with the keyboard, move to a starting cell with the arrow keys, then hold Shift while pressing an arrow key to extend the selection. For larger ranges, use Ctrl+Shift+Arrow on Windows to extend to the edge of a data block, or press Ctrl+G and enter a range such as B2:D8. These methods work in Excel for Microsoft 365 on Windows and let you select cells, rows, columns, and ranges without dragging the mouse.

What You’ll Need

  • A keyboard and a workbook open in Excel for Microsoft 365 on Windows. The shortcuts below are for Windows unless noted.
  • A worksheet where you can identify the cell or range you want. For a large or distant range, know its address, such as A1:C20.

You do not need to change a setting before using the standard selection shortcuts. If a cell is currently being edited, press Enter or Esc first: otherwise, arrow keys may move the cursor inside the cell’s text or formula instead of moving the active cell.

Step-by-Step

  1. Activate the worksheet and identify the starting point. Click a worksheet cell if needed, or use the keyboard to move focus into the grid. The selected cell is called the active cell; its border indicates where a new selection will begin. If you are editing its contents, press Enter to finish the edit or Esc to cancel it. Then use the arrow keys to reach the first cell you want. Up, Down, Left, and Right move the active cell one position at a time. If the arrow keys appear to move inside text, the cell is probably still in edit mode.
  2. Select adjacent cells one at a time. Hold Shift and press an arrow key. For example, go to B2, hold Shift, and press Right twice to select B2:D2. Keep holding Shift and press Down to extend the same rectangular selection into additional rows. The original cell remains the anchor, while the active edge moves. Let go of Shift when the selection covers the intended cells. If you extend too far, use the opposite arrow while still holding Shift to reduce the selection.
  3. Extend a selection across a block of data. Start at a cell inside the block, then press Ctrl+Shift+Right or Ctrl+Shift+Down to extend toward the next edge of the data region. For example, from A2, Ctrl+Shift+Right selects across the contiguous row data; Ctrl+Shift+Down extends through contiguous entries in the column. The result depends on blank cells: a blank in the middle can stop the extension or change where Excel stops. Check the highlighted edge before using the selection. To extend toward the other direction, use Ctrl+Shift+Left or Ctrl+Shift+Up.
  4. Select from the active cell to the beginning or end of the used area. Press Ctrl+Shift+Home to extend the selection toward the worksheet’s beginning, or Ctrl+Shift+End to extend it toward the last used cell. The active cell is the starting point, so choose it before using the shortcut. Ctrl+End by itself moves to the last used cell; it does not select the cells between there and your starting point. The worksheet’s used area can include cells that have been formatted or previously edited, even if they look empty, so Ctrl+Shift+End may select farther than the visible data.
  5. Select an entire row or column. To select the active cell’s whole column, press Ctrl+Space. To select its whole row, press Shift+Space. You can then use the arrow keys to move the active position while keeping the relevant row or column selected, or use the shortcut again after moving to select another one. Be cautious with these shortcuts before typing, deleting, or applying formatting: the selection includes cells outside the visible portion of the worksheet, not just the cells containing data.
  6. Select the current data region or the whole worksheet. Press Ctrl+A while the active cell is inside a contiguous data block to select that region. If needed, press Ctrl+A again to select the entire worksheet. The exact first selection can vary when you are in an Excel table or when the active cell is outside a data block, so look at the highlighted cells before acting. If you want to select the entire worksheet immediately, use the worksheet’s Select All corner at the intersection of the row and column headings; this is a mouse action, so Ctrl+A is the keyboard option to try first.
  7. Select a range by typing its address. Press Ctrl+G to open the Go To dialog. Type a reference such as B2:D8 in the Reference box, then press Enter. Excel selects the specified range, even when it is not currently visible. This is often quicker and more precise than moving across many rows or columns. You can also enter a single address, such as F25, to move to and select that cell. Check that you used a colon between the first and last cells of a range, and that you entered the correct sheet if you are navigating between worksheets.
  8. Add a separate range without losing the first selection. To build a nonadjacent selection using the keyboard, press Shift+F8 to turn on Add to Selection mode. Move to the next range with the arrow keys, then use Shift with the arrow keys to select its cells. Repeat to add more ranges, and press Esc when you have finished adding selections. Excel highlights each selected area separately. This is useful when you want to format or copy several distinct areas at once, but not every action works with nonadjacent selections. If the selection does not behave as expected, press Esc and make the ranges separately.
  9. Confirm the selection before making changes. Look for the highlighted cells and the active cell’s border. For a range selected through Ctrl+G, check that the address was entered correctly; for a shortcut selection, check for gaps or unexpected boundaries. Then perform the action you intended, such as applying a format or copying the range. If you only meant to move the active cell, release Shift before pressing another arrow. Pressing an arrow without Shift usually replaces a multi-cell selection with a single active cell.

Mac note: The basic Shift+Arrow selection works in Excel for Mac too. Many Mac keyboards use Command+Shift+Arrow to extend to the edge of a data region, and Command+G to open Go To; shortcut behavior can depend on the keyboard and macOS settings. Excel for Mac commonly uses Control+Space for a column and Shift+Space for a row, but Control+Space may conflict with a macOS input-source shortcut. If a combination is intercepted by the operating system, check or change that macOS shortcut, or use Excel’s menus and Go To dialog instead.

Common Mistakes

  • Pressing arrows while editing a cell. In edit mode, arrows move the insertion point within the cell’s contents. Finish or cancel the edit with Enter or Esc before trying to move or select worksheet cells.
  • Using Ctrl+Arrow when you mean to select. Ctrl+Arrow moves to the edge of a data region; it does not highlight all the cells along the way. Add Shift to make it Ctrl+Shift+Arrow and extend a selection.
  • Assuming blank cells do not matter. Ctrl+Shift+Arrow follows the structure of the data and can stop at a blank or jump across a blank area. If the result is not the range you want, use Shift+Arrow or enter an exact address with Ctrl+G.
  • Selecting a whole row or column by accident. Ctrl+Space and Shift+Space select far more cells than may be visible. Verify the highlighted row or column before deleting, pasting, or applying a change.
  • Confusing a move with a selection. Ctrl+End moves to the last used cell; Ctrl+Shift+End selects toward it. Similarly, Ctrl+Home moves to the beginning, while Ctrl+Shift+Home extends a selection toward it.

Tips

  • Use the shortcut that matches the shape of the task. Shift+Arrow is predictable for a small, continuous range; Ctrl+Shift+Arrow is efficient for a filled data block; Ctrl+G is easiest when you know the exact address.
  • Choose a good starting cell. For a rectangular range, begin at one corner and extend toward the opposite corner. If the selection goes in the wrong direction, use the opposite Shift+Arrow combination to adjust it before releasing Shift.
  • Keep an eye on the active cell. In a selected range, one cell remains active. Some commands, including typing a value, affect that active cell or the selected range differently, so confirm what is highlighted before entering or clearing content.
  • Use the status bar for a quick check. When multiple numeric cells are selected, Excel may show a summary such as Sum or Average on the status bar. This can help you notice that a selection includes more or fewer cells than expected, although it is not a substitute for checking the range itself.
  • Practice on a harmless area first. If a shortcut is unfamiliar, try it in an empty part of the sheet before using it on important data. This makes it easier to see whether the shortcut moved the active cell, extended a range, or selected an entire row or column.

Troubleshooting

The selection does not extend when I hold Shift. Confirm that you pressed and are holding Shift while tapping an arrow key, and that focus is in the worksheet grid rather than a dialog, formula bar, or cell edit. Press Esc to leave an active operation, click a cell, and try again. If you were using F8, note that F8 turns on Extend Selection mode; press F8 again or Esc to turn that mode off.

Ctrl+Shift+Arrow stops too soon or selects too much. Check the cells in the direction of travel for blanks, hidden data, or a larger contiguous block than expected. Use Shift+Arrow to adjust the edge in small steps, or press Ctrl+G and enter the exact address. If the data is arranged as separate blocks, select each block deliberately rather than assuming one shortcut will identify the intended boundary.

Ctrl+G does not open Go To. Make sure Excel, rather than another app or a cell-edit field, has keyboard focus. Press Esc once, then try Ctrl+G again. If a dialog appears, type the range in the Reference box and press Enter. On Mac, try Command+G. If a laptop function-key setting is involved in a different shortcut, use the keyboard’s Fn key where appropriate, but Ctrl+G itself should not normally require an F-key.

A Mac shortcut opens a system feature instead. macOS can reserve combinations that Excel also uses. Check System Settings for keyboard shortcuts that use the same keys, or use Excel’s Go To command and the Shift+Arrow method. Keyboard layouts and Excel versions can differ, so when in doubt, use the menu command and confirm the selection visually.

The highlighted range disappears when I press an arrow. That is normal if Shift is not held: an unmodified arrow key moves the active cell and replaces the selection. To expand or contract the selection, hold Shift throughout the arrow-key press. If you accidentally lost the range, repeat the selection using its address or starting cell.

Frequently Asked Questions

How do I select two or more adjacent cells in Excel?
Move to the first cell, hold Shift, and use the arrow keys to extend the selection. For example, from A1, Shift+Right twice selects A1:C1.

How do I select an entire column or row without a mouse?
Move to a cell in the desired column and press Ctrl+Space to select the column. Press Shift+Space to select the row containing the active cell. On Mac, Control+Space may be intercepted by macOS.

How do I select a range if I know its cell addresses?
Press Ctrl+G, enter a reference such as C4:F12, and press Enter. Excel selects that rectangular range directly. On Mac, use Command+G to open Go To.

Can I select cells that are not next to each other?
Yes. On Windows, press Shift+F8 to enter Add to Selection mode, navigate to another area, and select it with Shift+Arrow. Press Esc when done. If a command does not support a nonadjacent selection, apply it to each area separately.

What is the difference between Ctrl+Arrow and Ctrl+Shift+Arrow?
Ctrl+Arrow moves the active cell to an edge of a data region. Ctrl+Shift+Arrow extends the current selection from the active cell toward that edge. Blank cells and the surrounding data layout affect where Excel stops.

How do I select every cell in a worksheet?
Press Ctrl+A, and if the first press selects only the current data region, press Ctrl+A again. The result can depend on whether you are inside a table or data block, so check the highlighted area before making changes.

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.