Software

Ask something
Discussion Locked

Excel Headers

0 helpful
11 replies

by aburrus08

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way in MS Excel that you can format the headers to print on only the first page, not on every page?

11 replies

by sgt_shultz

Yep and Nope. "You can have only one custom header and one custom footer on each worksheet. If you create a new custom header or footer, it replaces any other custom header or footer on the worksheet."
so, make multiple worksheets? that is pretty easy to do.

by oz_media

YES, quite easily.

Put the header in the worksheet Eg. rows 1 through 3

Go to File|Page Setup|Sheet tab rows to repeat on top: 4:6 (say)

Make sure your print area includes those top three rows to print the header on the first page.

by dklippert

Just put your information at the top of the page. If you'd like, put your logo/information in a text box or AutoShape and format it anyway you'd like.

by hugo phurst

I do not believe Excel was meant to provide that level of complexity in document writing. However, MS-Office is designed so that all it?s applications can be combined. There are at least three ways of doing this, and in doing so you are then able to produce just the kind of headers and footers you desire.

1) Create a ?Binder? of Word Excel Word components .
2) Create a Word doc with a ?link to the excel spreadsheet.
3) Paste or Insert a spreadsheet directly into the document.

Now you can utilize all the Document creation features of word as well as utilize your spreadsheets and tables.

by rrrich7

Answer #2 is the easiest one, however, to be clear, you should know Excel calls that "Print Titles", not a header. When you set it up in Page Setup / Sheet tab, look for Print Titles and set rows 1-3 (or whatever) as the Titles

This discussion is closed to new replies.