Adding titles to formatted gridded workbook
 

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

Adding titles to formatted gridded workbook
 

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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kathy" wrote:

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

Adding titles to formatted gridded workbook
 

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

Either one should work.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 07:43:02 -0800, Kathy
wrote:

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