Working with Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Freezing worksheet panes

The ability to freeze, or lock, specific rows or columns in your spreadsheet is a useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly useful when working with large spreadsheets.

To freeze a row:

Freeze Pane
Freeze Pane
Freeze Pane

To unfreeze a pane:

To freeze a column: