Thread: Unable to freeze panes
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
[email protected] infodex@mindspring.com is offline
external usenet poster
  
Posts: 30
Default Unable to freeze panes
On Sun, 24 Feb 2013 14:21:14 -0500, wrote:

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.

Is this possibly connected to the other problem I had with Desktop
settings upsetting Excel? If not, what am I missing.

Nevermind.


I'm missing that freezing requires two steps: One to freeze the top
row, one to freeze the columns.

Sorry, back where I started. I can freeze one or the other but not
both.
Reply With QuoteReply With Quote