Select Table Row in Excel (Shift + Space)
The Select Table Row shortcut allows you to quickly select an entire row in your worksheet or table, which is useful for formatting, copying, or deleting rows without selecting cells individually.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Shift + Space | Shift + Space |
What Does This Shortcut Do?
Pressing this shortcut selects the entire row of the currently active cell within a table or worksheet.
How to Use the Shortcut
- Click on any cell within the row you want to select
- Press Shift + Space (Windows/Mac)
- The entire row will be highlighted
- You can now perform actions like copy, delete, or format on the selected row
Tips & Best Practices
- Combine with Ctrl or Command to select multiple rows
- Use before applying formatting to ensure consistent styling
- Works seamlessly with tables created using Ctrl + T
FAQ
- Q: Can I select multiple rows at once?
- Yes, after selecting the first row, hold Ctrl (Windows) or Command (Mac) and press Shift + Space on other rows.
- Q: Does it work on filtered tables?
- Yes, it selects the visible row even when filters are applied.