How to freeze rows in Google Sheets, insert multiple rows, delete empty rows

It's time to learn more about rows in Google Sheets. Learn how to insert new lines to your table – one or many at once; freeze rows in a spreadsheet in a few clicks; delete selected or only empty rows in your table. Some useful shortcuts and the add-on are there to ease your work.

• Select rows in Google Sheets
• How to insert rows in Google Sheets
  • Add one row to Google Sheets
  • How to insert multiple rows in Google Sheets
  • Insert lots of rows at the end of the sheet
  • Google Sheets: insert row shortcuts
• How to freeze rows in Google Sheets
• How to delete rows in Google Sheets
  • Google Sheets: delete row shortcuts
  • How to remove only blank rows in Google Sheets

Select rows in Google Sheets

Rows are one of the basic elements of Google Sheets. They are as important as columns in Google Sheets, and you need to know how to handle them to operate your data.

You can process either one row or a group of rows at the same time. Either way, you need to select the row first.

1. Select one row. To select a row, left-click its order number (a grey field with the row number on its left).
2. Select multiple adjacent rows. To select multiple adjacent lines, select the top row and drug the mouse till the last row required.

   Or click just the top row, then press and hold Shift on your keyboard, and then click the bottom row right away. All the rows between these two, including them, will be selected.

3. Select multiple non-adjacent rows. To select non-adjacent rows, click on them while pressing the Ctrl button on your keyboard.

Now the rows are selected and you can manage them.

How to insert rows in Google Sheets

Working with Google Sheets means constantly inserting multiple rows here and there. Before you start, check out these Google Sheets row limits to make sure there's enough room for new rows in your spreadsheet.

How to add one row to Google Sheets

1. Right-click the number of the row where you'd like to add one more.
2. Select Insert 1 above or Insert 1 below from the context menu:

   

3. Or go to the Google Sheets menu and click Insert > Rows > Insert 1 row above (or Insert 1 row below):

   

How to insert multiple rows in Google Sheets

1. Select as many row numbers as you want to insert.
2. Right-click them.
3. Pick Insert N rows above or Insert N rows below:

   

Insert lots of rows at the end of the sheet

What do you do when you need to add, say, 100 new lines? Should you select 100 existing rows so Google could offer a corresponding number? No, of course not.

No matter how many rows there are in your Google Sheets and how many you want to add, there's a feature that eases the job. Here's how you insert lots of rows to your Google Sheet:

1. Go to the very bottom of your table (Ctrl End).
2. You'll see the Add button. It's designed for cases like this.
3. Simply enter the number of rows you need to insert and click Add:

   

This number of new rows will appear at the end of your table.

Tip. Learn how to add rows from one table to another based on the contents in specific columns.

Google Sheets: insert row shortcuts

There are useful keyboard shortcuts to insert rows in Google Sheets. They are different for PC and Mac users.

Action	PC	Mac
Select row	Shift Space	Shift Space
Select more rows	Up Arrow / Down Arrow	Up Arrow / Down Arrow
Insert rows above	with rows selected: Ctrl Alt = in Google Chrome: Alt i, then r other browsers: Alt Shift i, then r	with rows selected: ⌘ Option = or Ctrl Option i, press r then r
Insert rows below	in Google Chrome: Alt i, then c other browsers: Alt Shift i, then c	Ctrl Option i, press r then b

How to freeze rows in Google Sheets

Everyone who works with large tables, sooner or later wants to freeze at least a header row in Google Sheets. This way, it won't disappear from the sheet when you scroll down the table and you will easily maintain context the whole time.

Of course, you can freeze as many rows in Google Sheets as you need, not only the first one. Here are two ways to do that.

1. Trick to freeze the rows in Google Sheets

1. Hover your mouse cursor right under column numbers till your cursor turns to a hand icon.
2. Click & drag-and-drop that thick borderline to whatever row you'd like to lock:

   

Tip. To cancel the changes and unlock all rows, choose View > Freeze > No rows in the Google Sheet menu:

or drag-and-drop that thick line back to column numbers:

2. Freeze rows in Google Sheets using the menu

1. Select any cell in the last row you want to keep visible.
2. Go to View > Freeze > Up to row N.
3. Or pick 1 row / 2 rows to lock the headers only:

   

Note. If you freeze more rows than can be displayed on your screen, you won't be able to scroll down the table. If that happens, you'll see a notification message and will be able to either resize your browser, change zoom settings or unlock everything back.

How to delete rows in Google Sheets

You can delete rows in Google Sheets the same way you add them:

1. Select as many rows as you want to delete.
2. Right-click them.
3. Pick Delete rows:

   

   Tip. Or make use of the Edit > Delete > Rows menu in spreadsheets:

   

Google Sheets: delete row shortcuts

Keyboard shortcuts to delete rows in Google Sheets exist as well. And they are also different based on your OC.

Action	PC	Mac
Select row	Shift Space	Shift Space
Select more rows	Up Arrow / Down Arrow	Up Arrow / Down Arrow
Delete rows	with rows selected: Ctrl Alt - in Google Chrome: Alt e, then d other browsers: Alt Shift e, then d	with rows selected: ⌘ Option - or Ctrl Option e, then d

How to remove only empty rows in Google Sheets

Sometimes a few empty rows may blend into your spreadsheet – when the data is removed, or for some other reason. Of course, no one wants blanks in their neat tables. So how do you remove blank rows in Google Sheets?

1. Remove empty rows manually

You could look through the whole table and delete those blank rows manually. But if the table is too large, it'll take a lot of time. Still, you can miss a row or two.

2. Filter blank rows

Sure, you can filter the rows, display only empty ones, and then get rid of them. But you'll have to filter each column, otherwise, risk deleting the lines that contain information in some columns only.

3. Power Tools add-on for Google Sheets

This add-on is a quick and reliable way to delete blank rows in Google Sheets. Install it for free from Google Workspace Marketplace and follow the steps below to remove blank rows in Google Sheets.

1. Open the tool & click the Clear icon:

   

2. Then open Remove empty rows & columns group.
3. And tick the boxes for those blank rows you want to remove:
   • empty rows (within your table)
   • unused rows (outside your table, makes your sheet shorter)
   • from all sheets

   

4. Then click Run, and the tool will do the job in less than a minute.

If you have any questions about Power Tools or rows in general, feel free to comment below.

The above is the detailed content of How to freeze rows in Google Sheets, insert multiple rows, delete empty rows. For more information, please follow other related articles on the PHP Chinese website!