How do I make JUST the header row always visible in Excel?

T

t.261

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?
 
G

Gord Dibben

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

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

Select B2 then Window>Freeze 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
 
Top