Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Freeze panes automatically freezes at r14 when I highlight r1?
When I highlight row 1 and click freeze panes, it automatically freezes at
row 14 and column B. I don't want that, I want only row 1 to be frozen. Is this a quirk in Excel 2000? Please help! Thanks Christene |
#2
|
|||
|
|||
Excel freezes above, and/or to the left of, the selection.
If you select cell A2, or row 2, row 1 will be frozen. If you select cell B1, or column B, column A will be frozen. If you select cell B2, row 1 and column A will be frozen When you select row 1, which has nothing above it, Excel "helps" you by freezing near the centre of the window. Christene wrote: When I highlight row 1 and click freeze panes, it automatically freezes at row 14 and column B. I don't want that, I want only row 1 to be frozen. Is this a quirk in Excel 2000? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi Christene
Select cell A2 and then freeze pane. This will freeze row 1 only. Always remember that cells above the active cell and towards the left of the active cell get frozen. And when there is neither a cell on top nor towards (example cell a1) the left excel by defalt puts the freeze pace in he center of the screen. Thanks Karthik Bhat Bangalore |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze panes automatically freezes at r14 when I highlight r1?
That was really helpful, because I had the same problem as christene, and
this answer really help me do what I wanted. Thanks, "Karthik" wrote: Hi Christene Select cell A2 and then freeze pane. This will freeze row 1 only. Always remember that cells above the active cell and towards the left of the active cell get frozen. And when there is neither a cell on top nor towards (example cell a1) the left excel by defalt puts the freeze pace in he center of the screen. Thanks Karthik Bhat Bangalore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze panes | Excel Worksheet Functions | |||
Freezing two columns in addition to Freeze Panes | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
Why does freeze panes work on one sheet but not on another in sam. | Excel Worksheet Functions |