Excel Header Question - Help

G

Guest

I have a 12 sheet workbook. I want to create headers with the format

xxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxx &Tab

so when it prints - the actual tab name prints. I have tried using the
Repeat page setup, but it puts the name of the tab I copied from as &Tab.

How is I create one header and have it repeat on each sheet with the correct
TAB name in it...

Please help

(e-mail address removed)
 
E

Earl Kiosterud

Rob,

The &Tab code should put the individual sheet name in the header, even if used via Repeat
Page Setup. I tested it with Excel 2003.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 

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

identify sheet number in header? 5
Drop Down List 4
Change Header on Multiple Sheets without Changing Other Formatting 1
Footer 1
How do I open multiple worksheets each in its own tab 3
Creating a header using non-contiguous rows 1
Excel Monthly Spread sheet. 12
Can't remove a number '3' from Excel header. 2

Top