View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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