Why is freeze panes grey

Thread starter jan Start date Mar 9, Tags excel freeze freeze panes panes unfreeze. Joined Jul 22, Messages A co-worker is working with an old spreadsheet - SaveAs indicates it was created, or at least last saved, in Excel Freeze Panes is grayed out and nothing I've tried so far has un-grayed it.

I did a SaveAs in which is what we all have on our computers at work to the format for Excel Workbook, so. No help. It did complain that it couldn't work with an embedded image, but that image wasn't "mission critical". Other than that, it saved it as far as I can see.

The sheet isn't protected. Is it just that there's too much of a gap between Excel and Excel ? Or is there an easy fix staring me in the face and I'm just not seeing it? Excel Facts. Using Function Arguments with nested formulas. Click here to reveal answer. Is the workbook protected? No, it isn't.

Details required :. Cancel Submit. Tom Ogilvy MVP. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Tom Ogilvy's post on October 18, I haven't found another reason although thee could be some.

A subscription to make the most of your time. Try one month free. Mainly there are 3 reasons behind this Excel Freeze Panes not working problem. If your Excel workbook is in page layout view then immediately change it to Page Break Preview or normal view. Well, this Windows option seems permanently disabled in Excel and To enable the Freeze Panes option again, you need to unprotect your Excel workbook:.

The appearance of a colored background behind the Protect Workbook indicates that protection is turned on. It only prevents you from freezing and unfreezing the worksheet pane until and unless your workbook is protected. Another method through which you can fix Excel freeze pane not working is by unfreezing the worksheet pane. On the View tab, in the Window group, click Freeze Panes. Chapter Worksheets. Download Excel File freeze-panes.

Next Chapter Format Cells.