Microsoft Excel:  Freeze Headings When Scrolling

If you have a large spreadsheet and find it difficult to keep track of which column or row belongs with which heading, you may want to freeze the column and/or row headings so they are always visible on screen no matter how far you scroll through your spreadsheet.

1. First, you need to create a split screen by going to the Window menu and select Split OR click and drag the Split Window bar above the Vertical Scrollbar or to the left of the Horizontal Scrollbar.
2. Place the split by dragging the bar to the location you desire.
3. Next, you need to freeze the panes by going to the Window menu and select Freeze Panes.

To (re)move the location of the split bar where the screen freezes, just follow the above directions in reverse.

1. Go to the Window menu and select Unfreeze Panes.
2. You can now move the split by dragging the bar to a new location or remove it completely by returning to the Window menu and select Remove Split OR drag the split off the screen.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.