In a company
or a school we have a number of students and employees and we maintain the data
of all of them but sub times a hindrance came when the data is very big and we
scroll the page and we don’t see the heading or if we scroll right we don’t see
the serial number or the name of that person. But for this we have an option in
the excel name freeze pane which help us to fix the heading, serial number or
the name or any other headings which we want to see after we scroll.
The freeze
pane option is mention in the view tab.
- If we only want to freeze the top cell/row then we have to click on freeze top row. So that the top row should be visible even after scrolling.
- If we want to see the left side of the page where the names are written then click freeze first column
- And if you want to fix both the top row and the first column then click on the freeze pane.
This option
make the work easier so that we can see the headings. The option looks like
given image.
