Custom List Header

[GeyserPeak]

Hello,
I am trying to make a custom header that will show up at the top of
each page. I have a long list (500 rows) of information with 7 columns,
and I have the headers in the cells at the top of the list, but I'd like
to have the column headers show up when I print it out without having to
go through and insert them at each page break (this might mess with my
formulas anyway). The custom header option only has left,right, and
center, and it looks like it will take a while to space the headers out
to match up correctly. Is there a better way to do this? Thanks in
advance.

 

[swatsp0p]

Hi, Geyser. Why don't you use the feature built in to Excel that allows
you to select rows to repeat at the top of each page? Go to File>Page
Setup and on the Sheet tab, enter the row(s) you want repeated on each
page and click OK.

Does this help?

 

[Dave O]

There is an easy way: click >File >Page Setup, select the Sheet tab,
and specify "Rows to Repeat At Top".