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.

How to Freeze Rows and Columns in Google Sheet

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.

How to Freeze Rows and Columns in Google Sheet

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.

How to Freeze Rows and Columns in Google Sheet

Selecting “Up to current row (6)” freeze first 6 rows. The below screen shows the output.

How to Freeze Rows and Columns in Google Sheet

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.

How to Freeze Rows and Columns in Google Sheet

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)”.

How to Freeze Rows and Columns in Google Sheet

Then the selected columns are freeze as below. A grey colored line is seen beside the freeze rows.

How to Freeze Rows and Columns in Google Sheet

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.

How to Freeze Rows and Columns in Google Sheet

Selecting “No columns” unfreezes the columns.