repeat info at bottom and top of every page

A

Andrew

I need to know how to repaetb the same information form the top and bottom of
a table on every page. It is not a pivot table.

Thanks,
 
D

Dave Peterson

Excel supports rows to repeat at top when you're printing.

File|page setup|sheet tab

It doesn't support a rows to repeat at bottom.

====
If you just want to see the same rows at the top on the screen, you can show the
rows you want to see (say 1:5), then click on A6 and window|Freeze Panes.

And there is no support for "freezing" rows at the bottom.
 
Top