Select Entire Row in Excel (Shift + Space)
Quickly select the entire row of the active cell without dragging. This is useful for formatting, copying, or performing operations on the full row.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Shift + Space | Shift + Space |
What Does This Shortcut Do?
Pressing this shortcut highlights the entire row of the active cell, including all columns in that row.
How to Use the Shortcut
- Click any cell in the row you want to select
- Press Shift + Space
- The entire row will be selected
Tips & Best Practices
- Combine with Ctrl (Windows) or Cmd (Mac) to select multiple rows
- Useful for applying formatting, deleting, or copying rows quickly
- Works in tables, ranges, and filtered data
FAQ
- Q: Can I select multiple rows at once?
- Yes, after selecting the first row, hold Ctrl (Windows) or Cmd (Mac) and select additional rows.
- Q: Does this work in filtered tables?
- Yes, it will select visible rows only.
- Q: Can I use this shortcut inside a table?
- Yes, the shortcut selects the entire table row corresponding to the active cell.