Google Sheets allow users to enter and save a heavy amount of data in the spreadsheet. It sometimes becomes difficult for users to sort out a large amount of data. In order to keep the track of data in the Spreadsheet, there’s an easy way to lock it in the place. Freezing Rows or Column headers locks the data in the place which makes it easier for the user to read data.
Learn How to Hide Rows and Columns in Google Sheets
In this guide, you will learn how to freeze a column or row header in google spreadsheets.
Freezing Row or Column Header in Google Spreadsheets
You can freeze any row or column that you want in google spreadsheets. Learn how to do it by following the guide:
- Launch the browser and open Google Spreadsheet in which you want to freeze a row or a column
- Click on View from the menu bar and select Freeze from the top of the menu.
- From the Freeze extended menu, select 1 row or 1 Column to freeze topmost column A or Row 1. Similarly, choose 2 rows or 2 columns to freeze the first 2 rows or columns.
- You can also freeze columns or rows up to your selected cell by selecting up-to row/column (number of row/column)
Also, learn How to add Rows & Columns in Google Sheets
In this way, you fix the row or column in its place and can move up and down the spreadsheet without disturbing the data. A thick grey border is placed between the frozen and non-frozen rows/columns to make the difference.
Related How to Generate Random Numbers in Google Sheets
How to un-freeze Rows or Columns
To unfreeze the rows or columns, select “No Rows” or “No Columns” from the Freeze extended menu. This will return the cells back to their normal layout.
You may like to check out How to Save Microsoft Word Document in “This PC” by Default