Deleting multiple rows

Select the first row header in the range and hold down the Shift key then you press the arrow keys to extend the selection. Alternatively, you can click the first row header in the range and then drag to the last cell.