Freeze panes in Excel worksheet

Freeze (panes) in Excel worksheet helps data to be kept in view!
It's quite frustrating to scroll up and down in large worksheets to see the column headings and determine what data you are viewing. You can avoid this unnecessary scrolling by freezing the headers or the columns or both.
If you wish to 'freeze' the headers and they are in row 2, you select the row 3 and then click on 'window' in the menu bar and select 'freeze panes'.
To freeze the columns that might be in column 'A' you need to select the column on the right (B) and again use freeze from the window menu.
If you wish to freeze both row and column while you view the rest of the data, select a cell below the 'header row' and to the right of the column you wish to have in view and then click on window and finally on freeze panes.
To summarize: You can freeze both column and row headings so that viewing data in large Excel worksheets through scrolling up, down or sideways is easy.

The video demonstrates 'freeze' in Excel. Click on the play button if required.




Further Reading

Freeze (panes) in Excel worksheet