The rule for freezing rows and columns is...........

Rows and columns above and left of the selected cell will be frozen.

Select B2 then WindowFreeze Panes.

Row 1 and Column A will be frozen.

If you select A1 then the freeze line will be at mid-window.


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 09:04:01 -0800, t.261
wrote:

I'm trying to manipulate data in a very large spreadsheet and need to keep
just the header row visible at all times while scrolling. The freeze option
freezes too many rows at one time. Can I adjust that somehow to freeze one
row and one column?