How to Freeze Multiple Rows at Top in Google Sheets

If you are a Google Sheet exploiter, you would have probably noticed that when you scroll down the top header rows disappear. While dealing with large-sized datasets, the chances are that you may forget each column's name calling and you are incapable to view them while scrolling. To overcome this issue, we will talk nearly the "Freeze Rows" in Google Sheets. Upon enabling this feature, Google Sheets leave lock the particular course(s). These rows volition and so be visible even while you coil down through your spreadsheet.

There are multiple ways by which you can give up rows in Google Sheets at top. Here are they.

Freeze Rows in Google Sheets Using Shortcut

You give the axe simply freeze rows in Google Sheets with a some clicks victimisation your mouse. You just necessitate to select the rows you want to frost and follow the stairs below.

Place your mouse pointer to the tipto left corner of the spreadsheet. Place it higher up the horizontal part of the grey surround as shown.

In one case the mouse cursor transforms into a paw-like icon, click and hang back it down to Row 1 if you want to Freeze only Row 1. Drag it till Rowing 2 if some Row 1 and Row 2 are to constitute frozen. Similarly, you can Freeze multiple rows in Google Sheets as per need.

There you have IT. Commencement, two rows are instantly Frozen, allowing an easy view of column heads during scrolling down.

Instead of dragging and dropping to lock rows in Google Sheets, you can utilize the Freeze function from the Google Sheets carte du jour.

Attend the top menu in Google Sheets. And then, click on the "View" pill. And, pick out the "Freeze" option.
From the drop-down, select the option to Freeze some number of rows. If you entirely want to Freeze Row 1, select "1 row". If you wish some Row 1 and Row 2 to be well-kept in a Frozen state, select the "2 rows" option from the drop-down pat.

Google Sheets Menu Function to Lock Rows in Google Sheets

Likewise, if you desire to Immobilise the first 25 rows, select a cell in Row 25. Over again, Go to the top menu in Google Sheets. Dawn on the "View" tab. Superior the "Freeze-*" option.
From the drop-down options, you will notice "Adequate to on-going wrangle(25)" given. Click on that option. This action will Freeze the first 25 rows with success.

As you can meet, the Google Sheets lock wrangle functionality is undiluted and straightforward to carry out.

Unfreeze Rows in Google Sheets Victimization Shortcut

What if you wish to Unfreeze the rows you did freeze to the top at a later o point? What is Unmelted john be Melted in Google Sheets. Let's see how to melt bolted rows in Google Sheets using computer mouse shortcut.

Place your mouse cursor below the Frozen row of the spreadsheet every bit shown.

Once the creep cursor transforms into a hand-like icon, click and drag it to the row in a higher place if you want to that row unequaled. For example, if Row 4 is frozen and you bid to unfreeze single that row, drag the hand-like icon dormie to Run-in 3. This litigate volition Unfreeze Wrangle 4.
If you desire to Unfreeze all rows, drag the mitt-look-alike icon in the lead to the spreadsheet's top left corner. This action will Unfreeze all rows.

Unfreeze Rows Using Google Sheets Carte du jour Selection

Like you can freeze out rows in Google Sheets, the menu also has the option to unfreeze single row or multiple rows in the spreadsheet.

Go to the top menu in Google Sheets. Then, clink on the "Aspect" tab. And, superior the "Freeze" option.
From the drop-down, select the option "No rows." This step will Unfreeze totally rows that were previously in the "Freeze" State Department.

Unfreezing of Rows is complete, and it is an effortless feature that makes the Google Sheets freeze row procedure easily reversible on call for.

As discussed here, you buttocks freeze multiple rows in Google Sheets in simple and speedy ways. This feature makes viewing large datasets in your spreadsheet rather convenient. It also lets you Freeze and Dissolve the Columns of spreadsheet information. This aspect makes scrolling and analyzing data horizontally inferior complex.

Revealing: Mashtips is subsidised by its audience. As an Amazon Associate I earn from qualifying purchases.