Freezing panes (Certain Rows/Columns having headings etc.) in Excel 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 diffifultIn 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 PANES options are found under VIEW tab in WINDOW subsection as shown in the picture.
The rows above the selected cell and column left to the selected cell will be frozen. When scrolled, rows and columns other than frozen will move.
UNFREEZE PANES-Unfreeze any of the frozen panes. No need to select any row or column. Just click unfreeze panes and it’ll unfreeze any frozen pane.
The button FREEZE PANES converts to UNFREEZE PANES if any of the cell is frozen.
The demonstration is given in the animated picture below.
FREEZE TOP ROW – Select these options and the top row will be frozen as per choice.
FREEZE FIRST COLUMN-Select this option to freeze the very first column of the sheet.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE