Adding titles to formatted gridded workbook

K

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
 
L

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?
 
G

Gord Dibben

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

Either one should work.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set default page setups for insert sheet in workbook 2
Printing Titles 2
sort a table without including titles which r on each page 3
Nameing cells in workbook 3
dynamically adding text to a mail message 5
How stop auto formatting? 2
Adding tabs to a workbook. 4
Adding Headers and Footer to an Entire Workbook?? 6

Top