View: Freeze Panes

Freeze Pane is similar to Split, however the Pane is "frozen," or locked into place. A Pane can be a Row, a Column or a Range.

 

Try This, Also: Freeze the Top Row

Open a sample Excel file, first.

The workbook is in Normal View, no Split.

Go to View->Window-> Freeze Panes.

Select: Freeze Top Row

 

 

What Do You See? The top row is frozen. It will remain anchored at the top of the screen as you scroll down to, say Row 57.

 

Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

4.2. Manipulate Window views: View Freeze Pane

 
View -> Window-> Freeze Panes