How To Select Multiple Rows In Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to select multiple rows in Google Sheets.

How To Select a Range of Rows In Google Sheets

Selecting multiple rows in Google Sheets is a useful skill to know for several different reasons.

Perhaps you want to delete all of the rows in a given range. Or you might want to select certain rows as an argument for a Google Sheets function.

Whatever the reason, learning how to select multiple rows in Google Sheets is a skill that can save you a lot of time.

Most actions in Google Sheets can be performed in batches based on what you have currently selected. For example, instead of applying a currency formatting one row at a time, you can simply select all rows that require the formatting and perform the action.

How To Select Two or More Rows In Google Sheets

Here’s how to select a range of rows in Google Sheets:

Step 1

First, click on the row you want to select. This is done by clicking on the row header labeled with the row number you want.

Step 2

Then, hold down the “Shift” key on your keyboard. Click on the last row you want to select. Holding the Shift key tells Google Sheets that you want to select all rows between the first and last row.

Step 3

Step 4

You may also use the Name Box to indicate the rows you want to be selected. Click on the Name Box on your spreadsheet’s upper-left hand side. You may also use the keyboard shortcut Ctrl + J to select the text box.

Step 5

Adjacent rows can be referenced by writing the row numbers of the first and last row in your desired selection separated by a single colon.

Step 6

Hit the Enter key after typing your desired range of rows. Multiple rows should now be selected.

Step 7

Excel also allows you to select multiple non-adjacent rows. After selecting the first row, hold the Ctrl key as you press the remaining rows in your desired selection.


This guide should be everything you need to know about how to select multiple rows in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.