How to Freeze Rows and Columns in Google Sheet
How to Freeze and Unfreeze Columns and Rows in Google SpreadSheets
In Google Docs, we can create and work on Docs, Sheet, and Slide online and remotely. Here we gonna talk about a tiny but very important function of Google Sheet: “Freezing Rows and Column”.
Let’s start the detailed guide:-
A) Freeze Rows in Google Sheets:
To freeze rows, open an Excel in Google Sheets and click on “View” option on the top menu. From the drop-down displayed, hover the pointer on “Freeze” option. This opens another sub-menu like below.
Next, click on “1 row” or “2 rows” option to freeze 1 row or 2 rows respectively. This freezes the first one or two rows as below.
A grey colored line is observed below the freeze rows.
If you want to freeze more rows, select the cell till where you want to freeze and click on “View” and select “Freeze”. For example, if a cell from the 6th row is selected, then an option “Up to current row (6)” is shown in the sub-menu.
Selecting “Up to current row (6)” freeze first 6 rows. The below screen shows the output.
B) Unfreeze Rows in Google Sheets:
To unfreeze rows, select “View” from the top menu and select “Freeze” option. It shows a sub-menu and selects “No rows” from the options.
Selecting “No rows” unfreezes the rows.
C) Freeze Columns in Google Sheets:
To freeze columns, select “View” from the menu, click on “Freeze” and select “1 column” or “2 columns” from the sub-menu to freeze the first one or two columns.
To freeze up to a selected column, select a cell in the required column. For example, to freeze up to column F, select any cell in column F and click on “View”, then select “Freeze” and click on “Up to current column (F)”.
Then the selected columns are freeze as below. A grey colored line is seen beside the freeze rows.
D) Unfreeze Columns in Google Sheets:
To unfreeze columns, select “View” from the top menu and select “Freeze” option. It shows a sub-menu and selects “No columns” from the options.
Selecting “No columns” unfreezes the columns.