How To Freeze Multiple Rows Or Columns In Google Sheets

Even supposing you prepare your Google Sheet record with alternating colours, running with a big information set can also be difficult. You continuously need to scroll throughout the spreadsheet to peer the entire information. Occasionally, you’d need to stay observe of one of the information as you scroll additional into the spreadsheet. That is conceivable by means of freezing the specified rows. Questioning how to try this? Observe this information to be informed how.

What Occurs When You Freeze in Google Sheets?

While you freeze cells or rows in sheets, the specific information will stay on-screen despite the fact that you scroll down within the sheet. That is very useful when running with numerous information, and you want to discover portions of the record. Frozen cells also are visual to others after they open the record.

Additionally, word that frozen rows stay in the similar place even while you type the information within the spreadsheet the usage of a filter out. 

How you can Freeze More than one Rows in Google Sheets at the Internet

Thankfully, you don’t want any third-party app or extension to freeze rows in Google Sheets. Additionally, the method of freezing unmarried or more than one rows is similar. 

1. Open your spreadsheet in Google Sheets.
2. Make a choice the row you need to freeze.
3. Click on View from the toolbar on the most sensible.
   
   
4. Make a choice Freeze.
5. Make a choice what rows you need to freeze from the choice.
   

As soon as carried out, you must see a thick line that separates the frozen rows from the remainder of the sheet. Without reference to the place you pass within the record, you’ll be capable of see the mounted rows on the most sensible.

You’ll additionally freeze columns by means of deciding on them from the Freeze menu. In the event you freeze by means of column, it must appear to be this:

On the other hand, you’ll be able to drag the freeze pane from the highest proper portion of the spreadsheet. Doing this will likely help you freeze the world the place you dragged the pane to.

How you can Unfreeze Rows in Google Sheets

While you’re carried out freezing the information, you’ll be able to unfreeze them anytime. Simply be sure to observe those steps.

1. Open the spreadsheet in Google Sheets.
2. Make a choice the row you need to freeze.
3. Click on View.
   
4. Make a choice Freeze after which make a selection No Rows (or No Columns in the event you iced up columns).
   

In case you are putting a calendar in Google Sheets, you must freeze the highest row for simple navigation.

How you can Freeze More than one Rows or Columns in Google Sheets From Android or iPhone

In the event you’re running on a spreadsheet the usage of the Google Sheets app for your telephone, you’ll be able to freeze rows or columns immediately from the cellular app. You don’t have to modify in your PC for this easy activity.

1. Open your spreadsheet in Google Sheets.
2. Faucet the row quantity (or column letter) of the cells you need to freeze.
3. Contact and dangle the highlighted rows or columns.
4. Make a choice the three-dot icon.
   
   
5. Faucet Freeze.
   
   

You’ll unfreeze the cells by means of going to the similar menu and deciding on Unfreeze.

Freezing Cells Make Managing Lengthy Spreadsheets More straightforward

This little trick is really useful, particularly in the case of spreadsheets that experience a whole lot of information. Do word that frozen cells are shared with everybody who has get right of entry to to the Google Sheets record, making it more uncomplicated for them to paintings at the spreadsheet, too. Subsequent up, you may need to be told the way to view who’s getting access to your Google Medical doctors or Sheets record.

FAQs