Having a top row containing the headings is common in almost every spreadsheet. But, if a sheet has a few hundred records, the row containing the heading can easily go out of sight while scrolling, resulting in several problems.
But, just like solutions to most other problems, Google Sheets also has the ability to freeze cells, just like Microsoft Excel. Not just one row or column, but you can freeze any number of rows and columns on Google Sheets. So, today I will talk about how to freeze top row in Google Sheets. This can be of great help if you are dealing with large sets of data.
How to freeze pane in Google Sheets?
Once you know, how to freeze top row in Google Sheets, you can freeze any number of rows, and even columns.
How to freeze top row in Google Sheets?
To freeze the top row in Google Sheets, open the sheet of your choice and simply click on ‘View’ on the menu bar. Now, move your cursor to ‘Freeze’, and then click on ‘1 row’.
Additionally, if you want to freeze the first column, which essentially consists of the serial number, click on ‘1 column’.
How to freeze more than one row in Google Sheets?
If you want to explore how to freeze more than one row in Google Sheets, or you want to freeze multiple columns, depending upon your specific scenario, here’s the guide.
If you want to freeze two rows and columns, click on ‘2 rows’, and ‘2 columns’.
If you want to freeze multiple rows and columns from the top or left respectively, simply select the last row or column to freeze.
Say for example, if you want to freeze all the rows up to 5, and columns up to F, select row 5, and then click ‘Up to row 5’, and then select column F, and click on ‘Up to column F’, in the ‘Freeze’ menu.
*In this situation, you can choose the cell F5 to get the option to freeze rows up to 5, and columns up to F.
So, that’s how to freeze the top row in Google Sheets effortlessly. Among the many other tips and tricks, knowing how to freeze pane in Google Sheets is really important. That way, you will never be lost while analyzing large sets of data. Knowing how to freeze top row in Google Sheets can be extremely useful if you are dealing with a data set having multiple fields.
So, that was all about how to freeze rows and columns in Google Sheets. Do you have any questions? Feel free to comment on the same below.
Comments
Post a Comment