Suppose a large table of data in Excel, then freeze will be useful.
By freeze one can keep rows or columns visible while scrolling through the rest of the worksheet.
Freeze Top Row
Freeze top row, following following steps -
1. On the View tab, in the Window group, click Freeze.
Click Freeze Top Row -
Now scroll down to the rest of the worksheet.
Excel will add a dark grey horizontal line to indicate that the top row is frozen.
To keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column.
Now UnFreeze Top Row -
To unlock all rows and columns, follow following steps-
On the View tab, in the Window group, click again Freeze Panes-
further one can also freeze row & columns
By freeze one can keep rows or columns visible while scrolling through the rest of the worksheet.
Freeze Top Row
Freeze top row, following following steps -
1. On the View tab, in the Window group, click Freeze.
Click Freeze Top Row -
Now scroll down to the rest of the worksheet.
Excel will add a dark grey horizontal line to indicate that the top row is frozen.
To keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column.
Now UnFreeze Top Row -
To unlock all rows and columns, follow following steps-
On the View tab, in the Window group, click again Freeze Panes-
further one can also freeze row & columns
