Select in Excel Without a Mouse: Keyboard Shortcuts

How-to basics · Updated November 20, 2026

To select cells in Excel without a mouse, move to a starting cell with the arrow keys, then hold Shift while pressing an arrow key to extend the selection. Use Ctrl+Shift+Arrow to select to the edge of a block of data, Ctrl+Space for a column, and Shift+Space for a row. For a specific range, press Ctrl+G, type its address, and press Enter. These steps are for Excel for Microsoft 365 on Windows.

Keyboard selection is useful when you are working hands-free, navigating a large worksheet, or need to select an exact range quickly. You do not need to change an Excel setting first. The main thing to know is whether you want to select nearby cells, a whole row or column, a data block, or a range you can name directly.

What You’ll Need

  • A keyboard and a workbook open in Excel for Microsoft 365 on Windows.
  • The cell address or range address, such as B2 or B2:D12, if you plan to jump directly to a particular selection.
  • For a non-adjacent selection, the addresses of each area you want, such as A2:A6 and C2:C6.

Excel for Mac has many equivalent shortcuts, but some keys vary by keyboard and macOS settings; the relevant differences are noted below. In Excel for the web, browser shortcuts can sometimes intercept key combinations, so Go To or the Name Box may be more dependable.

Step-by-Step

  1. Put the focus in the worksheet. If you have just opened a file, press an arrow key and check that the active-cell outline moves. If focus is in the ribbon, formula bar, or a dialog box, press Esc to leave the current control, then use an arrow key to return to worksheet navigation. The highlighted cell is the active cell; a selection can include that cell and other cells.
  2. Move to the starting cell. Use the Up, Down, Left, and Right Arrow keys to move one cell at a time. To move farther, press Ctrl+G, enter a cell address such as D15 in the Reference box, and press Enter. Excel selects that cell and makes it active. You can also move to the Name Box, type a reference, and press Enter; Ctrl+G is often simpler because it opens the Go To dialog directly.
  3. Select adjacent cells with Shift and an arrow key. Keep the starting cell active, hold Shift, and press an arrow key to add cells in that direction. For example, from B2, press and hold Shift and tap Right three times to select B2:E2. The active cell stays at the starting point while the selection expands. To shrink or change the selection, continue using Shift with an arrow in the direction you need.
  4. Extend a selection to the edge of a data block. Starting inside a continuous block, press Ctrl+Shift+Down, Ctrl+Shift+Up, Ctrl+Shift+Right, or Ctrl+Shift+Left. Excel extends the selection in that direction to the edge of the filled region. For example, if B2:B20 contains an unbroken list, place the active cell at B2 and press Ctrl+Shift+Down to select through the last adjacent filled cell. A blank cell interrupts this kind of movement, so check the data layout first.
  5. Select a larger rectangular range using the active cell and Go To. Press Ctrl+G, type a range such as B2:E20 in the Reference box, and press Enter. Excel selects the full rectangle, including any blank cells inside it. This is often the clearest method when you know both the first and last cell, and it avoids having to hold several keys while extending a selection across a large sheet.
  6. Select a whole column or row. To select the entire column containing the active cell, press Ctrl+Space. To select the entire row, press Shift+Space. The selection includes cells beyond the visible area, not just the portion currently on screen. To select several adjacent columns or rows, use the first shortcut and then extend with Shift and the appropriate arrow key. Press the shortcut again only if you understand how Excel is changing the selection in the current context.
  7. Select the current data region or the whole worksheet. Click is not needed: place the active cell inside a block of data and press Ctrl+A. In a typical range, the first press selects the current region around the active cell; pressing Ctrl+A again selects the whole worksheet. If you are editing a table or a formula, Ctrl+A can behave differently, so use Go To with an explicit address when the target must be exact. You can also use Ctrl+Shift+End to extend from the active cell to the last used cell in the worksheet.
  8. Select separate, non-adjacent ranges with Go To. Press Ctrl+G and enter a comma-separated union of references, for example A2:A6,C2:C6, then press Enter. Excel selects both areas without selecting the cells between them. This is useful when you need to format or copy separate columns together. If Excel does not accept the references as typed, enter each area separately through Go To, or confirm that the comma is the list separator used by your Excel settings.
  9. Use Extend Selection when you want to add cells without holding Shift. Press F8 to turn on Extend Selection, move with the arrow keys to expand the highlighted area, then press F8 again to turn the mode off. Check the status bar for the Extend Selection indicator so you do not leave the mode on accidentally. F8 may require the Fn key on some laptops. If you want to add a separate area rather than expand one continuous selection, press Shift+F8 to turn on Add to Selection, move to another area, and press Shift+F8 again to exit that mode.
  10. Verify the selection before acting on it. Look at the highlighted cells and, when using a single rectangular range, check the address shown in the Name Box. Then perform the intended action, such as applying a format or copying. If the selection is not right, use an arrow key to return to a single active cell and repeat the selection using a direct range address or the appropriate shortcut.

Common Mistakes

Using Ctrl+Arrow when you meant to select. Ctrl+Arrow moves the active cell to the edge of a data region; it does not by itself highlight the cells along the way. Add Shift to extend the selection: Ctrl+Shift+Arrow. If you pressed Ctrl+Arrow alone, the cells are not selected as a range.

Expecting Ctrl+Shift+Arrow to ignore blanks. A blank cell can stop the extension, and a blank separating two blocks means one shortcut may not select both. Use Ctrl+G and specify the exact range if you need to include cells across a gap.

Confusing a row or column selection with a visible-area selection. Ctrl+Space and Shift+Space select an entire worksheet column or row, including off-screen cells. If you only need a section, select its range by address instead, such as C3:C15.

Assuming Ctrl+A always means the whole worksheet. Its first action often selects the current data region, and tables or editing contexts can change what happens. Press it again only after checking the selection, or use Ctrl+G with the precise address.

Leaving a selection mode switched on. F8 and Shift+F8 change how later arrow-key presses work. If movement keeps extending or adding to the selection unexpectedly, press the same shortcut again to turn the mode off, or press Esc to cancel the current selection operation.

Tips

Choose the shortcut based on the shape of the target. Shift plus an arrow is best for a small adjacent selection. Ctrl+Shift plus an arrow is quick for a contiguous list or row of values. Ctrl+G is usually best for a large, exact rectangle or a selection with gaps because the cell addresses make the result explicit.

When selecting a list, start at a known end of the list and check for blank cells. If the list has a header in row 1 and values in rows 2 through 40, starting at A2 and using Ctrl+Shift+Down can select the values as long as they are continuous. If there might be blanks, use Ctrl+G and type A2:A40 so you do not stop early.

Remember that selection and movement are different. The arrow keys alone move the active cell, while holding Shift extends a selection. Ctrl+Arrow jumps across a data region, while Ctrl+Shift+Arrow selects as it moves. A quick mental check—“move, extend, or jump to an address?”—helps avoid changing or formatting the wrong cells.

On Excel for Mac, the Command key commonly replaces Ctrl for navigation and selection shortcuts that use Ctrl on Windows. For example, Command+Shift+Arrow extends toward a data-region edge in many Mac keyboard layouts. Control+Space may select a column, but macOS keyboard or input-source settings can reserve that combination; use the menu or Name Box if it is intercepted. Function keys such as F8 may also require Fn. On the web, try the same selection shortcuts, but use Go To or the Name Box if the browser captures a key combination.

Troubleshooting

The arrow keys scroll the sheet instead of moving the active cell. Scroll Lock may be on. Turn it off using the Scroll Lock key, if your keyboard has one. On some laptops, Scroll Lock is available through an Fn key combination or the Windows on-screen keyboard. Once it is off, arrow keys should move the active cell again.

A shortcut changes the ribbon or types into a cell. The worksheet may not have focus, or you may still be editing a cell. Press Esc once to cancel the current edit or close a menu, then press an arrow key and try again. If you are entering a formula, finish or cancel it before selecting a different range.

The selected range stops too soon. Look for a blank cell, a gap in the data, or the edge of the filled region. Use Ctrl+G and enter the full address to select across gaps. If you do not know the last row, use Ctrl+Down to move to the next boundary and inspect where the data ends before selecting.

F8 does not work. On a laptop, try Fn+F8; the function row may control brightness or volume by default. You can avoid Extend Selection entirely by holding Shift while using the arrow keys, or use Ctrl+G for a range you know.

Go To rejects a range or selects the wrong area. Check that the reference uses a colon between the start and end cells, as in B2:E20, and that the cell addresses are valid. For separate areas, use a comma between references where your regional settings permit it. If the Name Box is easier, type one range there and press Enter. Also confirm you are not typing into the active cell or formula bar.

Frequently Asked Questions

How do I select a whole column in Excel without a mouse?
Move the active cell into that column and press Ctrl+Space on Windows. On Mac, Control+Space is commonly used, but macOS settings can intercept it. To select only part of the column, use Go To and enter a range such as D2:D30.

How do I select an entire row without clicking its number?
Move to a cell in the row and press Shift+Space. To select several adjacent rows, extend the selection with Shift and the Up or Down Arrow key. Use an explicit range through Ctrl+G if you need only part of each row.

Can I select cells that are not next to each other?
Yes. Press Ctrl+G, enter a comma-separated reference such as A1:A4,C1:C4, and press Enter. This selects two separate areas. Regional list separators can vary, so if the comma is not accepted, select the areas separately or check the separator expected by your Excel settings.

What is the difference between Ctrl+Arrow and Ctrl+Shift+Arrow?
Ctrl+Arrow moves the active cell to an edge of the adjacent data region. Ctrl+Shift+Arrow extends the highlighted selection from the active cell to that edge. Use the second form when you want the intervening cells selected.

How do I select every cell in the worksheet?
Press Ctrl+A while in the worksheet; in many contexts, the first press selects the current region and a second press selects the whole sheet. If a table or editing context changes that behavior, use the Select All control at the top-left corner of the grid when available, or verify that the whole sheet is highlighted before acting.

Do these shortcuts work in Excel for the web?
Many do, but browser shortcuts can take priority, and some key behavior depends on the browser. Try the keyboard shortcut first; if it is intercepted, use the Name Box or Go To to enter the required cell or range reference directly.

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.