K
kris
When I freeze panes the verticle scrolling stops working but the horizontal
scroll still works. Any suggestions how to correct this?
scroll still works. Any suggestions how to correct this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
TK
It sounds the panes are frozen below the visible range of
the spreadsheet. Try unfreezing the window and move to the
top-left cell of the desired scrollable section of the
sheet and then re-freeze the panes.
Hope that helps,
Tom
the spreadsheet. Try unfreezing the window and move to the
top-left cell of the desired scrollable section of the
sheet and then re-freeze the panes.
Hope that helps,
Tom
M
Mandy11
When freezing panels you must be in the cell below and to the right of
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" and
"Address" so would I need to be in cell B2 when I freeze the panes.
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" and
"Address" so would I need to be in cell B2 when I freeze the panes.
M
Mandy11
When freezing panels you must be in the cell below and to the right o
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" an
"Address" so would I need to be in cell B2 when I freeze the panes
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" an
"Address" so would I need to be in cell B2 when I freeze the panes
M
Mandy11
When freezing panels you must be in the cell below and to the right o
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" an
"Address" so would I need to be in cell B2 when I freeze the panes
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" an
"Address" so would I need to be in cell B2 when I freeze the panes
M
Mandy
When freezing panels you must be in the cell below and to
the right of where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the
header "Name" and "Address" so would I need to be in cell
B2 when I freeze the panes.
the right of where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the
header "Name" and "Address" so would I need to be in cell
B2 when I freeze the panes.
M
Mandy11
When freezing panels you must be in the cell below and to the right o
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" an
"Address" so would I need to be in cell B2 when I freeze the panes
where you want the panels frozen.
Example:
A B
1 Name Address
2 Mandy Alabama
3 Chuck Philly
In this example I want to be able to see the header "Name" an
"Address" so would I need to be in cell B2 when I freeze the panes
S
Sandy Mann
Kris,
Does this happen in all workbooks or just one partucular one?
Regard
Sandy
Does this happen in all workbooks or just one partucular one?
Regard
Sandy
T
TK
Hmm...
Just a stab in the dark, but are there any merged cells
that extend below the header section? Maybe something like
that is interfering with the pane definitions.
Try removing all formatting from the top area of the
spreadsheet (select entire rows and use
the "Edit\Clear\Formats" menu command) and see if the
problem persists. If that does not solve it, I would try
copying everything to a new spreadsheet in case there is
some internal corruption in the workbook.
Good luck,
Tom
Just a stab in the dark, but are there any merged cells
that extend below the header section? Maybe something like
that is interfering with the pane definitions.
Try removing all formatting from the top area of the
spreadsheet (select entire rows and use
the "Edit\Clear\Formats" menu command) and see if the
problem persists. If that does not solve it, I would try
copying everything to a new spreadsheet in case there is
some internal corruption in the workbook.
Good luck,
Tom