Select the entire row

Master this Excel shortcut with our comprehensive guide

Row and Column Shortcuts Shift + Space Shift + Space

How to Use This Shortcut

Keyboard Shortcut
Shift + Space
Instructions
1. Press Shift + Space
2. Selects the entire row of the active cell
Keyboard Shortcut
Shift + Space
Instructions
1. Press Shift + Space
2. Highlights the entire row
💡 Pro Tip: Combine with Ctrl/Command + + to insert new rows.
Previous Collapse all fields in the Piv...
Next Select the entire column
Quick Actions
All Shortcuts Row and Column Shortcuts Print All
More Row and Column Shortcuts
Ctrl + Space
Ctrl + Shift + +
Ctrl + Shift + +