If you need to compare data or frequently visit a data set in Google Sheets, then it is quite a hassle to scroll back every time. Luckily, Google Sheets lets you freeze one or more rows and columns to stay on the screen even if you scroll to other parts of the sheet.
You can freeze these rows or columns in Google Sheets on desktop and Google Sheets mobile app. Here’s how to freeze rows or columns in Google Sheets.
How to Freeze Rows or Columns in Google Sheets PC Desktop
To freeze (freeze) rows or columns in Google Sheets, First you should know that you can only freeze rows from top to bottom or columns from left to right, you cannot select rows or columns from the middle.
Therefore, all required data must be in the first row/column of the sheet. Let’s see how you can freeze rows and columns in the desktop version of Google Sheets.
Click on the last row (if there is more than one) you want to freeze to select it.
Now click on the menu “Appearance” at the top and hover your mouse cursor over the option “Freeze“.
Many options will open to freeze rows and columns. You can select row/column 1 or 2, or all rows/columns before your selected row/column.
Once your choice has been made, you can scroll and see that the row/column will still be visible. Apart from that, you can also freeze rows and columns at the same time and they will all remain visible. The gray line will differentiate between frozen and regular rows/columns.
Once done, you can unfreeze rows/columns by going to menu Display> Freeze again and choose the option “No line” or “No column“.
How to Freeze Rows or Columns in Google Sheets Mobile
On the Google Sheets Android or iOS app, it’s actually easier to freeze rows or columns. Here’s how:
Open Sheet and tap the tab “Sheet” at the bottom. Now scroll down and you will see two options “Freeze Row” and “Freeze ColumnClick the up and down arrows next to them to select the number of rows and columns you want to freeze. The gray lines will show the selected rows and columns.
You can decrease or increase the number as needed, and you can dilute it by setting the number to 0.
Freezing rows and columns in one place is definitely the best way to keep content under control while you work on a sheet. Be careful when selecting multiple rows or columns to freeze because your screen should have enough space to display frozen data and regular data. You can always adjust the screen size if you really have to select multiple rows and columns to freeze.
That’s how to freeze rows or columns in Google Sheets either on PC or Android. Hopefully this article is useful, thank you for visiting and don’t forget to share it with your friends too.