How to Select a Row in Excel?

Click the row number on the left side of the worksheet

To select multiple adjacent rows, drag across the row numbers

To select multiple non-adjacent rows, hold Ctrl and click each row number

To select all rows, click the Select All button at the top-left corner of the sheet

To select a row using the keyboard, click any cell in the row and press Shift + Space

To select several rows with the keyboard, use Shift + Space on the first row, then hold Shift and press the Down Arrow or Up Arrow

To select an entire row range, click the first row number, hold Shift, and click the last row number

Suggested for You

Trending Today