To select cells in Excel with the keyboard, move to a cell with the arrow keys, then hold Shift while pressing an arrow key to extend the selection. For a filled block, use Ctrl+Shift+Arrow on Windows; for a whole row or column, use Shift+Space or Ctrl+Space. These shortcuts work in Excel for Microsoft 365 on Windows, with Mac differences noted below.
What You’ll Need
- A workbook open in the Excel desktop app. The steps below are for Microsoft 365 on Windows.
- A keyboard with arrow keys. If your keyboard uses an
Fnkey for navigation, you may need to hold it for certain keys such as Home or End. - For range-selection examples, a worksheet with some data is helpful but not essential. You can also try the shortcuts in a blank sheet.
Step-by-Step
- Place the active cell where you want to begin. Click a cell once, or navigate to it with the arrow keys. The active cell is the single cell with the darker outline; when you select multiple cells, it remains the starting or active cell within the selection. If Excel is currently editing text inside a cell, press
Escto leave edit mode before trying to select other cells. - Select nearby cells one at a time. Hold
Shiftand press an arrow key. For example, starting at B2, pressShift+Right Arrowtwice to select B2:D2. PressShift+Down Arrowto extend the selection farther down. Keep holding Shift as you press more arrows; release it when the range is the size you want. To shrink or change the edge, hold Shift and press an arrow in the opposite direction. - Select a continuous block of filled cells quickly. Put the active cell at one edge of the data, then press
Ctrl+Shift+Down ArroworCtrl+Shift+Right Arrowto extend the selection to the edge of the current data region. For example, if A2:A20 contains uninterrupted entries, place the active cell at A2 and pressCtrl+Shift+Down Arrowto select through A20. Use the other arrow directions to select toward the top or left. The shortcut stops at a blank cell or at the edge of the data region, so gaps can make the selection end sooner than expected. - Select from the current cell to the start or end of the used worksheet area. Press
Ctrl+Shift+Hometo extend the selection from the active cell to A1. PressCtrl+Shift+Endto extend it to the last cell Excel considers used. That last cell can be beyond the visible data if the sheet has previously had content or formatting there; this shortcut does not simply mean the last nonblank cell in the current column. To move without selecting, useCtrl+Homefor A1 orCtrl+Endfor the last used cell. - Select an entire row or column. Click or navigate to any cell in the row, then press
Shift+Spaceto select the whole worksheet row. PressCtrl+Spaceto select the whole worksheet column. These commands select the full row or column, not just the cells that contain data. To select more than one adjacent row or column, keep the row or column selection active and holdShiftwhile pressing an arrow key. - Select the current data region or worksheet. Press
Ctrl+Awhile the active cell is inside a block of data to select the current region, meaning the connected block bounded by blank rows and columns. Depending on context, pressingCtrl+Aagain can expand the selection to the entire worksheet. In a blank worksheet, it selects the whole sheet. In an Excel table, the first press may select table data; pressing it again can expand the selection. Check the highlighted area before applying an action such as formatting or deleting. - Go directly to a specific range. Press
Ctrl+Gto open the Go To dialog, type a reference such asB2:D10, and pressEnter. Excel selects that exact range, even if it is off screen or contains blank cells. This is useful when the target is large, far away, or awkward to reach with repeated arrow presses. You can also enter a single cell reference, such asF150, to jump straight to that cell. - Use the Mac equivalents where they differ. In Excel for Mac,
Shift+Arrowextends a selection in the same way. UseCommand+Shift+Arrowto extend toward the edge of a data region; the exact navigation behavior can depend on the keyboard and macOS settings. Excel for Mac commonly usesControl+Spacefor a column andShift+Spacefor a row, but macOS input-source shortcuts can conflict with Control+Space. For Go To, useControl+Gor the equivalent Go To command available in your Excel version. If a shortcut is intercepted by macOS, use Excel’s menus or change the conflicting system shortcut.
Common Mistakes
Pressing an arrow without Shift. An arrow key by itself moves the active cell, so the previous selection disappears. Hold Shift while pressing the arrow if you want to extend the highlighted range.
Expecting Ctrl+Shift+Arrow to stop at the last visible entry. It follows the boundaries of a contiguous data region. A blank cell in the middle can stop the selection; if the column contains gaps, use Ctrl+G and enter the precise range instead.
Confusing a data block with the entire sheet. Ctrl+A can select a connected region rather than every worksheet cell, and its behavior varies inside tables or other structured areas. Look at the selection outline and use the shortcut again when you genuinely need to expand it.
Trying shortcuts while editing a cell. If the cursor is inside the formula bar or cell text, arrow keys may move through the text instead of the worksheet. Press Esc to cancel editing, or Enter to finish the edit, then try the selection shortcut.
Assuming the active cell is the whole selection. A multi-cell selection still has one active cell. Some commands, such as typing a value, may affect the active cell or the entire selection depending on how you confirm the entry. Confirm the highlighted range before making changes.
Tips
- Use
Shift+Arrowfor a small, precise range andCtrl+Shift+Arrowfor a quick extension across a continuous block. Start at the edge you want to anchor so the range grows in the right direction. - For an exact range that includes blanks, use
Ctrl+Grather than relying on the data-edge shortcut. For example, enteringC5:F25selects that rectangle whether or not every cell is filled. - To select a rectangle with a predictable endpoint, move to its first cell, hold
Shift, and navigate to the opposite corner. You can also use Go To when the destination is far away; after selecting the starting cell, the range can be entered directly in the Go To dialog. - For adjacent columns, select one column with
Ctrl+Space, then holdShiftand press Left or Right Arrow. For adjacent rows, useShift+Space, then hold Shift and press Up or Down Arrow. - Selection is not the same as copying. A highlighted range is ready for formatting or another command, but it is not on the clipboard until you press
Ctrl+C. PressEscto clear a copy marquee or leave a selection without changing its contents.
Troubleshooting
The shortcut moves the cursor but does not select. Confirm that Shift is held down at the same time as the arrow key. If Excel is editing a cell, press Esc or Enter first. On some laptops, arrow keys may share functions with another key, so check whether Fn is required.
The selection stops too early. Look for a blank cell or a gap in the data. Ctrl+Shift+Arrow stops at a data-region boundary rather than selecting an arbitrary number of rows. Use Ctrl+G and type the exact range if you need to include blank cells, or select the next section separately.
The selection includes far more cells than expected. A stray value or formatting can affect the used range, especially with Ctrl+Shift+End. Press Ctrl+End to see where Excel thinks the used area ends. For a smaller, defined area, use Go To with a specific reference instead of selecting to the last used cell.
Ctrl+Space does something else on a Mac. macOS may reserve that shortcut for changing input sources. Try Excel’s column-selection command from the menu or keyboard settings, or change the conflicting macOS shortcut. The Windows shortcut should not be assumed to behave identically on a Mac.
Ctrl+A selects the wrong area. Check whether the active cell is inside a table or a connected block of data. Pressing the shortcut again may expand the selection; otherwise, press Esc and use Ctrl+G to specify exactly what you want.
Frequently Asked Questions
How do I select all cells in an Excel worksheet using the keyboard?
Press Ctrl+A. If you are inside a data region or table and the first press selects only that area, press it again to expand the selection. You can also use the Select All button at the top-left corner where the row and column headings meet.
How do I select a range without dragging the mouse?
Move to the first cell, hold Shift, and use the arrow keys to reach the opposite edge. For a range with known coordinates, press Ctrl+G, enter a reference such as A2:C12, and press Enter.
Can I select nonadjacent cells with the keyboard?
Excel has an extend-selection mode: press F8 to extend a selection with navigation keys, and press Esc to stop extending. To add a separate, nonadjacent range, press Shift+F8 to enter Add to Selection mode, navigate to the next range, and select it; press Esc when finished. Laptop function-key settings may require holding Fn. Because this mode can be less obvious than a simple range selection, check the status bar and highlighted cells as you work.
What is the difference between Shift+Arrow and Ctrl+Shift+Arrow?Shift+Arrow extends by one cell at a time. On Windows, Ctrl+Shift+Arrow extends to the edge of a connected data region, or to the next region boundary when there are blanks. Use the first for fine control and the second to move quickly through filled data.
Do these shortcuts work in Excel for the web?
Many basic shortcuts, including arrow keys, Shift+Arrow, and Go To, are available in Excel for the web, but browser shortcuts can sometimes take precedence and some behavior differs from the desktop app. If a command does not respond, check Excel’s Help for keyboard shortcuts or use the on-screen controls. On Mac, macOS and browser shortcuts may also affect which keys Excel receives.
Related
- Save an Excel File as a Copy: Step-by-Step Instructions
- How to Save an Excel File in Google Sheets
- How to Save an Excel File in Read-Only Mode: Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Identify Duplicate Numbers in ExcelTo find duplicate numbers in Excel, select the cells and choose Home > Conditional Formatting > Highlight Cells…
- Security Risk in Excel: How to Find and Check It SafelyTo find security risks in an Excel workbook, first check where it came from and whether Excel shows…
- How to Add Checkboxes in an Excel File on SharePointTo add checkboxes to an Excel workbook stored on SharePoint, open the workbook in Excel, select the cell…
- Excel PivotTable Dates: How to Ungroup Them EasilyTo ungroup dates in an Excel PivotTable, click a grouped date label, then choose PivotTable Analyze > Ungroup…
- Protect an Excel File From Opening With a PasswordTo stop people opening an Excel workbook without permission, open it in the Excel desktop app and choose…
- How to Freeze a Cell in Excel Without Losing Your PlaceTo keep headings or identifiers visible while you scroll in Excel, select the cell just below and to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.