When working with Google Sheets, you will have to handle dozens of columns of data. And if you make mistakes because there are many columns, you should freeze unused columns, or hide columns or rows to make the Google Sheets table more compact.
Columns or rows that have been frozen or hidden will no longer be displayed or clickable to operate. If we freeze the title row, we can also read the document more easily. Besides, freezing columns also has many different options, in addition to freezing the first row or column. The article below will guide you how to freeze and hide rows and columns in Google Sheets.
Video tutorial on freezing and hiding columns and rows in Sheets
1. Freeze Google Sheets columns and rows
Step 1:
Click on the row or column you want to freeze, then click See choose next Permanent.
This time displays additional options for fixing columns and rows. If you click 1 row or 1 column, the first selected row and column freeze. If you press 2, the first 2 rows or 2 columns will be frozen.
Step 2:
The row or column results you selected have been frozen. They are Fixed with gray border to separate it from the rest of the area, and cannot move no matter where you drag the mouse to.
If the user wants Freeze entire rows or columns then first of all Click on the last box in rows and columns that need to be frozen. Google Sheets will calculate from the first row and column of numbers down to the exact position you click. Then click Seeselect continue Permanent then select next Go to current row/column.
For example, to freeze from the first row to the 6th row, you will click on cell 5. At this time, Google Sheets calculates that there are 6 rows that need to be frozen.
The results of the first 6 rows have been fixed.
Step 3:
If you want unfreeze columns or rows Users click on View, select Fixed and then select There are no rows (columns)..
2. Hide columns and rows in Google Sheets
Step 1:
First Click on the column header at the top then press right mouse select Hide columns.
Now the selected column is hidden and okay symbol with 2 arrows on either side of the hidden column. If clicked arrow icon hey then column will automatically display.
Step 2:
To hide rows in Google Sheets The user also does the same, Click on the first order box of the goods and choose Hide items.
The result is that the row has been hidden and an arrow icon also appears to indicate that the row has been hidden. To re-display the row, just click on the arrow icon.
Freezing rows and columns and hiding rows and columns in Google Sheets is very simple and easy to do. Once done, users cannot operate on locked or hidden areas, so it is easier to tidy up the data table.
Wishing you success!
