Headers and Footers Accros Workbooks

G

Guest

I have created a header & footer on the first sheet of my Excel document.
When I created sheet two which has two pages, the H&F hasn't transferred. If
I add a new H&F it starts the page numbers from 1 again.

When I print the entire workbook, I want the pages numbered consecutively so
is there any way of applying a H&F across an entire workbook?
 
D

Damon Longworth

Try selecting all sheets then apply your headers and footers.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
 

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

transferring headers and footers 1
How to copy a range of cells and paste into a new workbook in differentcolumns 3
Updating Headers/Footers in VB 1
Linking headers and footers 1
Copy Headers and Footers between wookbooks 1
Consecutive Numbered Pages 2
How to copy headers/footers between worksheets 2
How to copy headers/footers across worksheets 5

Top