Adding titles to formatted gridded workbook

[Kathy]

I have created a very large workbook in Excel 2003 with many worksheet tabs.
It is all formatted and gridded the way I want it. I want to add a title to
the top of each page outside of the gridded area. How do I do this? When I
try headers and footers in page setup it wants to put the title inside my
grid overlaying something else already in there. TIA

 

[Luke M]

You're on the right track with headers. But, you want to go to setup-margins,
and make sure the "Top" margin (distance from edge of sheet to data) is
greater than "Header" margin (distance from edge of sheet to header). So,
maybe 1" for top, 0.5" for header?

 

[Gord Dibben]

Move your top margins down a bit or make the footer area larger.

Either one should work.


Gord Dibben MS Excel MVP