Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / May 2005

Tip: Looking for answers? Try searching our database.

Prevent headers from printing on the first page of workbook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ibvalentine - 12 May 2005 18:11 GMT
I want to use headers in a workbook but I don't want to print the header on
the first page. The first spreadsheet is more than one page. How do I do it?
Nick Hodge - 16 May 2005 22:16 GMT
Two print jobs I'm afraid, with headers/footers not on and just page 1
printed and then headers/footers entered and then print from page 2 on.

This could be automated with VBA or you could copy and paste the data into
Word and use the feature in there. Excel is not great for print features.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>I want to use headers in a workbook but I don't want to print the header on
> the first page. The first spreadsheet is more than one page. How do I do
> it?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.