In this article I will discuss how you can freeze rows in Google Sheets. To learn more about different hacks, tips and advice for working with Google Sheets, you can go through other articles from TeqTog and see if anything comes to your help.
Okay then, let us get started!
Why do you Need to Freeze Rows?
When you are working on Google Sheets, you will have to move around your data all the time. From scrolling down to scrolling to the right; you will seldom just stay at one place in your spreadsheet while working.
Now, when you are moving away from your rows or columns, you may lose track of what data you are on or what each data stands for. This is why you have to lock your rows and even your columns in place. So that when you are navigating around your dataset, you can still view the rows and columns which tell you what data you are on.
Methods of Freeze Rows and Columns in Google Sheets
One thing is for certain and that is, it is very simple to do this task. Holding your rows and your columns in place is really easy and a few quick steps are all you need to learn.
These are some of the methods of freezing rows and columns in their places in Google Sheets:
- Freezing rows and columns with the menu (quick)
- Freezing rows and columns with the mouse
Unfreezing rows and columns. (Because once your freeze rows or columns, you might need to unfreeze them as well)
Freezing Rows and Columns in Google Sheets with the Menu (Shortcut)
Let me start with this easy method of freezing your rows through the menu options. Below is a dataset that represents the number of Covid-19 cases across ten different areas.
1. Suppose I want to lock the top row of my dataset which has the titles. To do this, I will first select all of the cells in my top row.
2. Second, I will click on the “View” option from the top menu bar.
3. Then, from the drop down menu I will select “Freeze”
4. Afterwards, from the second drop down menu, I will select “Freeze 1 row”
5. I have now successfully locked the top row. Now, I can scroll down as much as I would like and still have my top row visible.
Points to Note: You cannot freeze both the rows and columns at the same time. You will have to freeze the rows and columns one after the other; one at a time.
If you want to freeze a number of rows instead of just once; then do the following:
- Select any cell on the row number till which you want all the rows prior to it to freeze. For instance, if you wish to lock the first three rows, then click on any cell on the third row and freeze using the same steps.
- For freezing columns, follow the same steps and choose the “Freeze 1 column” option instead of row.
Freezing Rows in Google Sheets and Columns with the Mouse (Easiest)
This method is even simpler.
1. On the top left corner of your spreadsheet, find the small empty box. Place your mouse over that box without clicking. Your mouse cursor should change into the hand cursor sign.
2. Once it has changed into the hand sign, hold the thick gray line of the box by clicking on your mouse’s right key. Now, drag the length of the box till as far the first row.
3. You should have locked the first row of your dataset.
4. If you need to lock the first column; just drag the width of the box till as far as the first column.
How to Freeze More Than 2 Rows and Columns in Google Sheets
How to freeze more than 2 columns in Google Sheets ….
Unfreezing Rows and Columns in Google Sheets
Once you freeze rows or columns you will need to release them as well. Below are ways in which you can do this.
Release/Unfreezing by the Mouse Option
You can release frozen rows and columns by dragging the width or the length of the small box back to its original size.
Unfreezing/Release by the Menu Option
- Just as before, select “View” from the top menu.
- From the drop down menu select “Freeze”
- To unfreeze rows, you need to select “No rows”.
- To unfreeze columns, you need to select “No columns”.
There you go! I hope my tutorial on how to freeze rows and columns in Google Sheets could help you. Keep on visiting TeqTog for more tips.
Best of luck!
More Google Sheets Tutorial to Read: