How do I make a header row appear at top of each page (not cell#)
 

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?

How do I make a header row appear at top of each page (not cell#)
 

File -- Page Setup -- Sheet tab

You should see a field called "Rows to repeat at top"

Fill in, or select, your rows here.

HTH,
Elkar


"Crazy4Dogz" wrote:

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?

How do I make a header row appear at top of each page (not cell#)
 

For printing:
File|page setup|sheet tab|rows to repeat at top

For viewing:
Select A1 (just to make sure it's visible)
select a cell (say B2)
window|freeze Panes

Everything to the left of that selected cell (b2 in my sample) will be frozen.
Everything above that cell will be frozen.



Crazy4Dogz wrote:

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?

--

Dave Peterson

How do I make a header row appear at top of each page (not cell#)
 

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?

One way:

File Page setup Sheet Rows to repeat at top