View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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