View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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