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
