To select an entire row in Excel, click any cell in that row and press Shift+Space on Windows. Excel for Mac uses the same shortcut. The row is selected across the worksheet, including blank cells, so you can format, copy, hide, or work with the whole row at once.
This guide covers Excel for Microsoft 365 on Windows first. The shortcut is also available in current Excel for Mac; in Excel for the web, it works when the worksheet grid has focus, though a browser or keyboard setup may affect it. If the shortcut does not work, the row-number header is a dependable alternative.
What You’ll Need
- A workbook open in Excel, with the worksheet you want to change visible.
- A keyboard with a Shift key. No special setting, formula, or add-in is required.
- Optional: if you use Excel for the web, make sure the worksheet grid is active rather than the browser address bar or another control.
Step-by-Step
- Open the correct worksheet. Select the sheet tab at the bottom of the Excel window. If the workbook has several sheets, check the tab name before selecting a row; the shortcut acts on the active sheet only.
- Choose a cell in the row. Click any cell in the row you want, such as D12 if you want row 12. It does not matter whether the chosen cell contains a value, a formula, or nothing. The active cell is the starting point Excel uses to determine which row to select.
- Press Shift+Space. Hold down Shift and tap the spacebar once. On a standard Windows keyboard, do not add Ctrl or Alt. In Excel for Mac, use Shift+Space as well. Excel should highlight the selected row and its row number at the left edge of the grid.
- Check the selection before acting. Look for the highlighted row number and the selection spanning the grid. The active cell may remain white or show a border within the highlighted area, depending on the workbook theme. That does not mean only that one cell is selected: the row is selected when the row header is highlighted too.
- Choose what to do with the row. You can apply formatting from the Home tab, copy the selection with Ctrl+C on Windows or Command+C on Mac, or use the right-click menu. To hide it, right-click its row-number header and choose Hide. To delete a whole worksheet row, use Home > Delete > Delete Sheet Rows, or right-click the row header and choose Delete. Be careful: the Delete key by itself clears cell contents; it does not remove the worksheet row.
- Select several neighboring rows if needed. For a keyboard approach, select a cell in the first row, press Shift+Space, then hold Shift and press the Up Arrow or Down Arrow to extend the selection to adjacent rows. Check the highlighted row numbers as you extend it. You can also select a continuous block with the mouse by dragging over the row headers, or click the first row header and Shift-click the last row header.
- Return to a single cell when finished. Click the cell where you want to continue, or use the arrow keys to move the active cell. If you are about to edit or paste, confirm that the intended row or rows are highlighted so you do not change a larger range than expected.
Excel Table note: If the active cell is inside a formatted Excel Table, Shift+Space can select the table’s data row rather than the entire worksheet row on the first press. Press Shift+Space again to expand the selection to the full worksheet row. A table row selection is limited to the table columns, so check the selection before formatting or copying if you need cells outside the table included.
Common Mistakes
Using the wrong shortcut. Ctrl+Space selects a column, not a row. Shift+Space is the row shortcut. If your screen highlights a vertical strip or a column header, undo the selection by clicking a cell and use Shift+Space instead. Keyboard shortcuts are easy to mix up because both use the spacebar.
Pressing the shortcut while editing a cell. If you double-clicked a cell, pressed F2, or started typing, Excel may be in cell-edit mode. In that state, the spacebar can add a space to the cell text instead of selecting the row. Press Esc to leave edit mode, click the cell once, and try Shift+Space again. If you have already changed text, use Ctrl+Z on Windows or Command+Z on Mac to undo the edit before continuing.
Assuming the Delete key removes the row. With a row selected, Delete usually clears the selected cells’ contents while leaving the worksheet row in place. To remove the row and shift cells below it upward, use the Delete Sheet Rows command or the row-header context menu. If you only wanted to clear values, the Delete key may be the right choice; decide which result you need before pressing it.
Confusing a table row with a worksheet row. A table has its own boundaries and may highlight only the table’s portion of a row. That selection can be enough for sorting or table formatting, but it does not necessarily include cells to the left or right of the table. Press Shift+Space again when you need the entire sheet row, and verify the row-number header is selected.
Tips
- Use the row header as a visual check. A selected row is identified by its row number being highlighted, not just by a border around one cell. This quick check is useful before copying, formatting, or deleting.
- Select a row even when the first column is blank. You do not need to click the first populated cell. Click any visible cell in the target row, including a blank one, then use Shift+Space. This is useful in worksheets with spacer columns or data that begins well to the right.
- Use the mouse as a fallback or for a range. Clicking a row number selects that worksheet row directly. Drag down the row-number headers to select several adjacent rows. This method is especially clear when the selection includes a table, hidden columns, or a large block of data.
- Keep the shortcut separate from the action. Selecting does not itself change data. Once the row is highlighted, choose the specific command you want. For example, use the Home tab’s formatting controls to change appearance, or use the row-header menu for row operations. This separation helps prevent accidental deletion.
- Remember the Mac modifier differences for other actions. The row-selection shortcut itself is Shift+Space on both Windows and Mac. Some follow-up shortcuts differ: copy is Ctrl+C on Windows and Command+C on Mac. If you use Excel for the web, the browser may handle some key combinations differently, so the ribbon and context menus are useful alternatives.
- Take care with hidden or filtered data. Selecting a worksheet row includes cells across the row, even if some columns are hidden. In a filtered list, selecting a visible row and applying an operation can have consequences beyond what is currently displayed. Review the selected row and the intended command before making a bulk change.
Troubleshooting
Nothing happens when you press Shift+Space. First click a cell in the worksheet, not the formula bar, Name Box, ribbon, or a dialog. Then press Esc once in case Excel is editing a cell, click the target cell again, and retry. In Excel for the web, click inside the grid to give it focus. If the browser still intercepts the shortcut, click the row number at the left of the sheet instead.
A space appears in the cell. Excel was probably in edit mode. Use Ctrl+Z or Command+Z immediately if the extra space changed the cell, then press Esc to leave editing. A single click on the cell should make it active without placing a text cursor inside its contents.
Only part of the row appears selected. If you are in a table, press Shift+Space a second time and check whether the selection expands beyond the table. If you are not in a table, verify the row header highlight. In unusual views or at high zoom, the selection shading can be subtle; clicking the row number is a reliable way to confirm or reselect the full row.
The shortcut types a character or behaves unexpectedly. Check that Shift is being held while you tap the spacebar, and that another window or pop-up is not active. If you are using a compact keyboard, the spacebar should still work normally; do not substitute a key combination such as Ctrl+Space. Try the row-header method to continue, then check your keyboard layout or browser settings if the shortcut keeps failing.
You cannot delete, format, or hide the selected row. The selection may be correct while the worksheet is protected or the workbook has restricted editing. Check the Review tab for sheet protection controls or ask the workbook owner for access. A protected sheet may permit selecting cells but block changes, so a highlighted row does not guarantee that every action is allowed.
Frequently Asked Questions
What is the shortcut to select an entire row in Excel?
Click any cell in the target row and press Shift+Space. This selects the worksheet row on Windows and Mac. In a table, a first press may select only the table row; press again to expand the selection.
How do I select multiple entire rows with the keyboard?
Select a cell in the first row, press Shift+Space, then hold Shift and press the Up or Down Arrow to extend the highlighted rows. Check the row numbers afterward. For a large or nonadjacent selection, using the row headers with the mouse is often easier.
Does Shift+Space work in Excel for Mac?
Yes. Excel for Mac uses Shift+Space to select the row containing the active cell. Some other shortcuts differ between Mac and Windows, but this row-selection combination is the same.
How can I select a row without using a shortcut?
Click the row number along the left side of the worksheet. To select several adjacent rows, drag across their row numbers or click the first row number and Shift-click the last one.
Why does Shift+Space select only part of my row?
You may be working inside an Excel Table, where the first press can select the table’s data row only. Press Shift+Space again for the entire worksheet row, then check that the row-number header and the cells beyond the table are included.
Does selecting a row delete its contents?
No. Shift+Space only selects the row. Pressing Delete clears cell contents, while the Delete Sheet Rows command removes the worksheet row itself. Confirm which result you want before choosing a deletion command.
Related
- How to Repair Excel Desktop App: Windows Steps and Fixes
- Rename a Sheet in Excel Without a Mouse
- How to Rename a Sheet in Excel Using the Keyboard
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Copy a Dropdown in Google Sheets: Steps and FixesTo copy a dropdown in Google Sheets, copy the cell that contains it, select the destination cell, and…
- How to Insert a Check Box in Word With a Keyboard ShortcutFor a quick, printable check box in Microsoft Word on Windows, type 2610 and press Alt+X; Word converts…
- Excel Remove Duplicates: Keep the Last Matching RecordExcel’s Remove Duplicates command keeps the first matching row it encounters; it has no built-in option to keep…
- Excel Column Letter to Number List and Conversion GuideExcel columns use letters, but each letter or letter combination has a number: A is 1, Z is…
- Compare Documents in Word: A Step-by-Step GuideTo compare two versions of a document in Microsoft Word, open Word and choose Review > Compare >…
- Google Sheets: Count Cells That Contain Text ValuesTo count cells containing text in Google Sheets, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. It counts text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.