ExcelBanter - View Single Post

[email protected]

On Sun, 24 Feb 2013 14:14:19 -0500, wrote:

Another mystery with Excel 2010.

I have an existing spreadsheet in which I had frozen first column and
top row. The freeze has disappeared and I cannot reinstate it. When I
pull down the Freeze Panes button it has only two freeze options:
Freeze Top Row and Freeze First Column. No way to freeze both.

FWIW, this spreadsheet was originally created and frozen in Excel
2003. I don't know how it got unfrozen in 2010 but whatever it was I
can't seem to undo it.