How to select multiple rows in Google Sheets

You can watch a video tutorial here.

Google Sheets is a popular spreadsheet application in which the workspace is arranged in rows and columns. You may need to select multiple rows either to format them or to move them to another location.  There are different ways to select rows that are adjacent to each other and those that are not.

Option 1 – Select adjacent rows

Step 1 – Select the first row

  • Click on the row header/number
  • The row is selected

Step 2 – Select the other rows

  • Hold down the mouse button and drag to select the other rows

OR

Hold down the Shift button and click on the other row numbers that are to be selected

Step 3 – Check the result

  • Multiple rows are selected

Option 2 – Select non-adjacent rows 

Step 1 – Select the first row

  • Click on the row number
  • The row is selected

Step 2 – Select the other rows

  • Hold down the Ctrl key
  • Click on each row header that is to be selected

Step 3 – Check the result

  • Non-adjacent rows are selected