PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Freezing panes (Certain Rows/Columns having headings etc.) in GOOGLE SHEETS is very important when we are working with big and lengthy reports .
In very large reports having many columns or rows, it becomes difficult to remember the column names and we are confused which is very irritating.
We need to scroll up the report over and again to remind us of the column or row headings.
It happens at the time of creating reports as well as when we are checking or reviewing them.
When the reports are sent to somebody, this problem emerges again.
So , our topic, freezing panes give us the solution to this very problem.
Even if we are creating the reports or we are studying them, it is always needed to know about the column or row headings otherwise it would be difficult In that case, freezing panes is very helpful as it fixes our Rows Headings or Column Headings sticking to our screen while the data can scroll up or down or left or right .
FREEZE ROWS options are present under the VIEW MENU in GOOGLE SHEETS.
Google Sheets has different options for freezing the top rows or left columns. We will discuss them one by one.
The TOP ROW of the sheet will be frozen.
Google Sheets has different options for freezing the top rows or left columns. We will discuss them one by one.
The TOP TWO ROWS of the sheet will be frozen.
Google Sheets has different options for freezing the top rows or left columns. We will discuss them one by one.
Google Sheets has different options for freezing the top rows or left columns. We will discuss them one by one.
The LEFT ONE OR TWO COLUMNS of the sheet will be frozen.
Google Sheets has different options for freezing the top rows or left columns. We will discuss them one by one.
UNFREEZE ROWS OR COLUMNS-If we want to unfreeze the rows or columns , we can follow the following steps.
After choosing both of the options all the freezing will be removed either it is present in the rows or columns.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE