Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Freeze pane problem
When I freeze the panes on my worksheet by clicking on cell A1 it
automatically freezes it right in the middle of the page. It freezes as if I had H19 highlighted. Why is this happening? Is there somewhere to change freeze pane options? I must be missing something |
#2
|
|||
|
|||
Hi J-
When you apply the Freeze it relies on where your Active Cell (Cell Selector) is at the time. By having it on A1 it _can't_ freeze any columns to the left or rows above because there aren't any. Therefore it just centers the freeze lines in the current window. Put your selector in C5 & when you turn the feature on columns A & B will be frozen in place and rows 1 thru 4 will be frozen in place. HTH |:) "J Diamond" wrote: When I freeze the panes on my worksheet by clicking on cell A1 it automatically freezes it right in the middle of the page. It freezes as if I had H19 highlighted. Why is this happening? Is there somewhere to change freeze pane options? I must be missing something |
#3
|
|||
|
|||
THank CyberTaz, I'm an idiot. Oh well, I guess I don't know as much as I
thought "CyberTaz" wrote: Hi J- When you apply the Freeze it relies on where your Active Cell (Cell Selector) is at the time. By having it on A1 it _can't_ freeze any columns to the left or rows above because there aren't any. Therefore it just centers the freeze lines in the current window. Put your selector in C5 & when you turn the feature on columns A & B will be frozen in place and rows 1 thru 4 will be frozen in place. HTH |:) "J Diamond" wrote: When I freeze the panes on my worksheet by clicking on cell A1 it automatically freezes it right in the middle of the page. It freezes as if I had H19 highlighted. Why is this happening? Is there somewhere to change freeze pane options? I must be missing something |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
freeze pane in a web page | Excel Discussion (Misc queries) | |||
Freeze Pane command freezes more cells than I selected. | Excel Worksheet Functions |