Unable to freeze panes

I

infodex

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.

Dick
 
I

infodex

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.
Click to expand...

Nevermind.


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

Claus Busch

Hi,

Am Sun, 24 Feb 2013 14:21:14 -0500 schrieb (e-mail address removed):
I'm missing that freezing requires two steps: One to freeze the top
row, one to freeze the columns.
Click to expand...

to freeze rows and columns is only one step:
Select a single cell and freeze pane - the columns to the left of the
selected cell and the rows above the selected cell will be frozen.
E.g. you select C3: Columns(A:B) and Rows(1:2) will be frozen.


Regards
Claus Busch
 
C

CellShocked

Hi,

Am Sun, 24 Feb 2013 14:21:14 -0500 schrieb (e-mail address removed):


to freeze rows and columns is only one step:
Select a single cell and freeze pane - the columns to the left of the
selected cell and the rows above the selected cell will be frozen.
E.g. you select C3: Columns(A:B) and Rows(1:2) will be frozen.


Regards
Claus Busch
Click to expand...


why does 2013 not have windowed open file panes?

They are all stuck maximized, and separate full excel windows pop to
the desktop front for each file. This is like some Windows 8
consideration thing. Some of us have multiple displays, and this new
pair-of-dimes is a departure from a windowed motif. Not necessarily
affecting multi-display setups per se, but still, one has to adjust one's
ways and means yet one more time... how quaint... not!
 
C

Claus Busch

Hi Mick,

Am Sun, 24 Feb 2013 11:37:56 -0800 schrieb CellShocked:
why does 2013 not have windowed open file panes?

They are all stuck maximized, and separate full excel windows pop to
the desktop front for each file. This is like some Windows 8
consideration thing. Some of us have multiple displays, and this new
pair-of-dimes is a departure from a windowed motif. Not necessarily
affecting multi-display setups per se, but still, one has to adjust one's
ways and means yet one more time... how quaint... not!
Click to expand...

sorry Mick, but I didn't realize that the problem is based on Win8 and
Office2013.
I'm still working with Office2007 and Office2010 and Vista as OS.


Regards
Claus Busch
 
I

infodex

Nevermind.


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

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

infodex

Hi,

Am Sun, 24 Feb 2013 14:21:14 -0500 schrieb (e-mail address removed):
Click to expand...

I was mistaken on this.
to freeze rows and columns is only one step:
Select a single cell and freeze pane - the columns to the left of the
selected cell and the rows above the selected cell will be frozen.
E.g. you select C3: Columns(A:B) and Rows(1:2) will be frozen.
Click to expand...


How do you freeze them? The Freeze Pane button has Freeze Row or
Freeze Column but not both.
 
I

infodex

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.
Click to expand...


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.
 
C

Claus Busch

Hi,

Am Sun, 24 Feb 2013 15:14:24 -0500 schrieb (e-mail address removed):
How do you freeze them? The Freeze Pane button has Freeze Row or
Freeze Column but not both.
Click to expand...

my Excel 2010 has three buttons:
1. Freeze sheet pane => that worked as I posted before
2. Freeze Top Row
3. Frist first columns


Regards
Claus Busch
 
I

infodex

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.
Click to expand...


I'm really perplexed. Not only can I not freeze both row and column, I
can only freeze the first column heading wheras I previously had
frozen the headings of the first three columns.
 
I

infodex

Hi,

Am Sun, 24 Feb 2013 15:14:24 -0500 schrieb (e-mail address removed):


my Excel 2010 has three buttons:
1. Freeze sheet pane => that worked as I posted before
2. Freeze Top Row
3. Frist first columns
Click to expand...


Something very weird going on here.

My Freeze Pane button only drops down into Unfreeze, Freeze Row, and
Freeze column.

After you posted this, I tried it once more and lo and behold there
was a Freeze Pane selection on the drop down. I selected that and it
worked fine. However, when I closed the file and reopened it the
freeze was gone and now there is no Freeze Pane selection on the drop
down.
 
I

infodex

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.
Click to expand...


Whatever it is, it is a problem with this specific spreadsheet. I can
create a new one and it has a Freeze Panes option on the Freeze Panes
drop down.
 
I

infodex

Whatever it is, it is a problem with this specific spreadsheet. I can
create a new one and it has a Freeze Panes option on the Freeze Panes
drop down.
Click to expand...

It seems to have been a corrupted file. I copied and pasted everything
to the new file and it works fine.

Thank you for the assistance.

Dick
 
C

CellShocked

Hi Mick,

Am Sun, 24 Feb 2013 11:37:56 -0800 schrieb CellShocked:


sorry Mick, but I didn't realize that the problem is based on Win8 and
Office2013.
I'm still working with Office2007 and Office2010 and Vista as OS.


Regards
Claus Busch
Click to expand...


I am not in Windows 8, but my excel 2013 behavior in Windows 7 is what
I referred to. Sorry I ddin't make that clear when I suggested why it
might be that way.
 
C

CellShocked

Something very weird going on here.

My Freeze Pane button only drops down into Unfreeze, Freeze Row, and
Freeze column.

After you posted this, I tried it once more and lo and behold there
was a Freeze Pane selection on the drop down. I selected that and it
worked fine. However, when I closed the file and reopened it the
freeze was gone and now there is no Freeze Pane selection on the drop
down.
Click to expand...


So... UNFREEZE everything, and start over. perhaps it will only let
you stack them in a certain order.
 
J

jdrish

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.



Dick



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.



Dick



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.



Dick
Click to expand...

I had a similar problem and found out that it was the view. Are you in the normal view?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any way to get Freeze Panes to work with Split View? 2
Freeze top 2 rows - how 3
Excel 2007 - freeze multiple panes? 2
Freeze multiple rows/columns in Excel 2007 7
Freeze column headers for ledger sheets 1
Freeze Panes 5
MS Excel Freeze panes based on selection does not work for me 4
Freeze Panes bug when grouping columns and sharing a workbook 1

Top