How to Freeze a Row and Column in Google Sheets

How to freeze a row and column in google sheets 19

In this article, we will learn how to freeze a row and column in google sheets.

Freezing a row or column can be very helpful when working on large datasheets, we many times face the complexity of too much data appearing in our sheet so that’s why we use the freeze method we can freeze and unfreeze our rows and columns without losing their data, functionality or position.

How to freeze a row and column in google sheets 1

See also  How to Use Google Finance Function in Google Sheets (Beginner's Guide)

Advantages of using Freeze Function in Google Sheets

The freeze function is really useful and very important for complex data sets. Datasets like pay orders and payroll are highly loaded and most of the data is not required all the time. By using the frozen row and column feature we can freeze the top most important rows and work on the below spreadsheet. We don’t need to scroll up and scroll down, again and again, to see the important things from the top of the datasheet we can easily freeze top rows and they will be frozen. They will not leave their sticky position and keep appearing on the top either we scroll down or scroll up.

Let’s see how it works using several methods.

See also  How to Make a Button in Google Sheets (3 Methods)

Two Ways to Freeze Rows and Columns in Google Sheets

Freeze Rows & Columns using Main Menu

In the main menu method, we can freeze rows and columns by going to View > and then Freeze > pick an option from the given four options according to your need and click on it.

Step 1

Go to View > Freeze

How to freeze a row and column in google sheets 1

Step 2

Select an option from the four given options for rows and similarly for columns

How to freeze a row and column in google sheets 3

How to freeze a row and column in google sheets 4

How to freeze a row and column in google sheets 5

How to freeze a row and column in google sheets 6

Step 3

Check your sheet. It will be frozen

How to freeze a row and column in google sheets 7

How to freeze a row and column in google sheets 8

How to freeze a row and column in google sheets 9

See also  How to Apply Conditional Formatting Strikethrough in Google Sheets

Freeze Rows & Columns using Shortcut

Hover on the header of the column, until your cursor changes into a hand cursor. Then drag below up to the rows till where you want to freeze.

Similarly for columns, hover on the left-most corner origin and wait for the hand cursor and then drag rightward until the column you want to freeze.

Step 1

Hover on the headers of the columns until you get the hand cursor.

How to freeze a row and column in google sheets 10

Step 2

Left Click, and drag your mouse below.

How to freeze a row and column in google sheets 11

Step 3

A transparent line will be indicating you the freeze span. Left the left-click button and scroll to see the freeze effect.

Step 4

Similarly for the columns

How to freeze a row and column in google sheets 12

How to freeze a row and column in google sheets 13

See also  How to Make a Beautiful Chart in Google Sheets (User Guide)

How to Freeze a Specific Row in Google Sheets

You can freeze a specific row in google sheets very easily by following the below steps. But remember that a specific row can be the top row or any row connecting with row 1. It means that you can not separately freeze any row until it’s the first row. This limits the functionality of the freeze function. But currently, we don’t have any alternative in google sheets to freeze a middle row specifically.

Step 1

Go to view > Freeze

Step 2

Click on “ 1 row”. It will freeze the very first row. You can also select “2 rows” to freeze the top 2 rows.

How to freeze a row and column in google sheets 1

Also remember that you can not freeze a middle column, like if you want to freeze column number 10. Google sheets do not allow to do that. You can only freeze rows or columns from the top or left side.

You can freeze up to an nth number of rows and columns if it is starting from the top row or leftmost column.

See also  How to Add a Date Picker in Google Sheets [Complete Guide]

How to Freeze a Row in Google Sheets App

Freezing rows in google sheets are very simple, we have two methods as we discussed above, a direct main menu method, and another is a shortcut method using mouse. The mouse method is mostly used and is recommended because it is fast.

We can freeze the first row, top 2 rows, and as many rows as we want but with the combination starting from row1. We can not freeze only row number 10 or 15 or even 2. But we can freeze rows 1-2, 1-3, 1-100, etc.

This is how the google sheets freezing feature works. Don’t get overwhelmed by finding a way to freeze a specific row other than the top row. There is no such way. The same goes for the columns.

Step 1

Go to View > Freeze.

Step 2

Select an option to freeze the row as per your need.

How to freeze a row and column in google sheets 5

See also  How to use NOT Function in Google Sheets [With Examples]

How to Freeze a Header Row in Google Sheets

So the headers that contain A B C are automatically frozen by default. The next header row is the first row that mostly contains the headers of the data. So we can easily freeze the header row here by using the same method. Considering it as the first row we can use the following two same steps to freeze it.

The headers are normally more likely to be frozen by the data manager for themselves and also for their users to easily navigate and manipulate through it. The most simple way to freeze the header row is to hover your mouse over the header row, and slowly move your mouse to the left or right side until the arrow cursor changes to the hand cursor. After you have got the hand cursor, then just drag it by holding the left-click of your mouse, a transparent guideline will appear and help you understand the rows that are going to be frozen from your action.

If this sounds too confusing then you can refer to this method in the above shortcut method section, where we have defined this method step by step with screenshots.

If you still don’t like this method then you can use the below method which is the menu method.

Step 1

Go to View > Freeze.

Step 2

Select “up to row 1” or “1 row” both are identical if you select any cell of the first row (header row).

How to freeze a row and column in google sheets 14

How to freeze a row and column in google sheets 15

How to Freeze a Column in Google Sheets App

Just like rows, we can also freeze columns in google sheets, and the google sheets app. for google sheets, simply follow the below easy steps to freeze columns.

For columns, keep in mind that the column index starts from the left, and goes towards the right. Column A is column number 1.

Step 1

Go to View > Freeze

How to freeze a row and column in google sheets 1

Step 2

Select an option from no columns, 1 column, 2 columns, up to n columns. (n is the number of columns currently selected.

How to freeze a row and column in google sheets 20

Freeze 1 Column

How to freeze a row and column in google sheets 21

How to freeze a row and column in google sheets 24

Freeze 2 Columns

How to freeze a row and column in google sheets 22

How to freeze a row and column in google sheets 25

Freeze Up to Column N

How to freeze a row and column in google sheets 23

How to freeze a row and column in google sheets 26

See also  Version History in Google Sheets (Complete Beginner's Guide)

How to Freeze Columns in Google Sheets App

Mobile apps are widely used, if you’re using the google sheets mobile application, and you want to freeze your columns then you can easily do it without any hurdle using your smartphone.

Simply follow the below steps to freeze the column from your smartphone google sheets application.

Step 1

Open google sheet app

Step 2

Select any row or column header

How to freeze a row and column in google sheets 16

Step 3

From the popped-up menu click on three dots

Step 4

Click Freeze

How to freeze a row and column in google sheets 17

Step 5

Repeat the same steps to unfreeze

How to freeze a row and column in google sheets 18

Note that you can also freeze and unfreeze rows similarly using the mobile app of google sheets. The only difference in the selection is if you select rows and perform the above step then rows will be frozen or unfroze

See also  How to Add a Trendline in Google Sheets [Complete Guide]

How to freeze row and column in google sheets

We have discussed how to freeze rows and columns, now we can easily freeze rows and columns at once. It is as simple as you like. Where we used the menu method to freeze a row and then a column, we will use both options one after another to freeze the row and column at once.

This is so simple.

Step 1

Identify the rows and columns you want to freeze

Step 2

Select any cell from the row you want to freeze and go to View > Freeze

How to freeze a row and column in google sheets 1

Step 3

Pick an option to freeze the row

How to freeze a row and column in google sheets 3

Step 4

Select any cell of the column you want to freeze and go to View > Freeze

Step 5

Pick an option to freeze the column

How to freeze a row and column in google sheets 21

You have successfully frozen rows and columns as per the requirement.

How to freeze a row and column in google sheets 19

See also  How to use DIVIDE Function in Google Sheets [User Guide]

How to Unfreeze Rows and Columns in Google Sheets

How to freeze a row and column in google sheets 2

How to freeze a row and column in google sheets 20

To recap we have seen how to freeze a row and column google sheets using several scenarios. We also discussed the basic rule for freezing the google sheets. And the most important thing is that the middle row of columns can not be frozen using any method, either by google apps script. So never try to freeze a middle row or column. Keep your data professionally appealing and avoid using the freeze function unnecessarily. It is more likely to be used for freezing headers, or sometimes a column that contains important data.
See also  How to Group Rows in Google Sheets (Best Practice)

Notes

  • Remember that, a middle row or column can not be frozen using any method in the google sheets.
  • You can freeze the 1st row or 1st column, and from the 1st row to the nth row, similarly for columns.
  • If you have seen somewhere that a middle row or column is frozen, so let me clear it is possible in Microsoft excel. It is done by using the split function. This function split the entire sheet into two or more parts, and then the 1st row of each part can be frozen and similarly for columns
  • You can easily freeze rows or columns using the shortcut method that is defined above.
  • Try to use the shortcut method, it is fast and easy.
  • Mostly you need to freeze your data headers only, so never overdo this feature.

See also  How to Use Google Finance Function in Google Sheets (Beginner's Guide)

Conclusion

Congratulations for being till the end. hope you enjoyed the article and you have learned many new things about the freeze function in google sheets. Now you can play around with your data and make it more appealing and convenient for the users by freezing the important top rows that help avoid a lot of scrolling and saves a lot of time. That’s all from how to freeze a row and column in google sheets.

If you like our article please share it with your social networks and don’t forget to subscribe to the Office Demy blog for future updates. Thank you!

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general