Unable to select "Freeze Panes"
Solved/Closed
Boo
-
Sylvie -
Sylvie -
Hello,
First of all, I want to point out that I am not very knowledgeable about computers.
My problem is the following:
I am trying to freeze a row in an Excel table. I know I have to select FREEZE PANES in the WINDOW menu, but it is impossible to select it... It is grayed out...
Does anyone know how to solve this?
Thanks in advance for the help!
Boo
First of all, I want to point out that I am not very knowledgeable about computers.
My problem is the following:
I am trying to freeze a row in an Excel table. I know I have to select FREEZE PANES in the WINDOW menu, but it is impossible to select it... It is grayed out...
Does anyone know how to solve this?
Thanks in advance for the help!
Boo
Configuration: Mac OS X Safari 4.0.3
6 réponses
Hi,
First, click on an Excel cell located on the row from which you want to freeze.
Then go to the menu you mentioned.
Here is a visual explanation.
Ritchi
First, click on an Excel cell located on the row from which you want to freeze.
Then go to the menu you mentioned.
Here is a visual explanation.
Ritchi
Hello,
In my wild youth, there was a scrollbar in Excel with a slider at the top of the vertical scrollbar and another one on the left of the horizontal scrollbar. By dragging these sliders, we could freeze title rows and columns. One or several of each, by the way...
Best regards.
In my wild youth, there was a scrollbar in Excel with a slider at the top of the vertical scrollbar and another one on the left of the horizontal scrollbar. By dragging these sliders, we could freeze title rows and columns. One or several of each, by the way...
Best regards.
Thank you very much for the responses!
Chris 94, by doing what you suggest, it splits the selected row or column. I would like to freeze a row...
Ritchi, that is indeed what I do; I select a cell, or even an entire row, below the one I want to freeze (I've tried both cases). But when I go to the Window menu to select Freeze Panes, I can't because it's grayed out, so it's impossible to select...
Chris 94, by doing what you suggest, it splits the selected row or column. I would like to freeze a row...
Ritchi, that is indeed what I do; I select a cell, or even an entire row, below the one I want to freeze (I've tried both cases). But when I go to the Window menu to select Freeze Panes, I can't because it's grayed out, so it's impossible to select...
I have read many answers on this topic in forums, this is the only one I found providing this information.
Have a nice day