How to Select Entire Row in Excel?

Click the row number on the left side of the sheet

Press Shift + Spacebar

Use Ctrl + Spacebar to select the entire column instead

Drag across multiple row numbers to select multiple rows

Hold Shift and click another row number to select a range of rows

Hold Ctrl and click row numbers to select non-adjacent rows

Suggested for You

Trending Today