follow me on facebook follow me on twitter Instagram

Freeze Panes

I am often asked why Freeze Panes is grayed out and therefore why they can't select it.

First make sure you are not in edit mode. Usually if an item on the ribbon is not available it is because you are in edit mode. Hit ENTER to finish what you are doing or hit ESC to get out of edit mode if you are in there accidentally.

The second reason Freeze Panes is grayed out is because you are not in Normal View. Freeze Panes only works in Normal View. 

Click on the first of the three icons in the bottom right corner of the screen. Just before the Zoom bar.
View / Normal  [in the Workbook Views section]

Blog post on How to Freeze Pane

No comments:

Post a Comment