Freeze panes automatically freezes at r14 when I highlight r1? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Christene 8/2/2005 9:22 AM PST   Question   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     Was this post helpful to you?         Reply |   Top           Debra Dalgleish 8/2/2005 9:52 AM PST   Answer   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     Was this post helpful to you?         Reply |   Top           Karthik 8/2/2005 10:08 AM PST   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     Was this post helpful to you?         Reply |   Top           Nihar Upadhyaya 6/18/2008 9:43 AM PST   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 > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies