Workbook Page Numbers

  • Thread starter Thread starter Darrell Lankford
  • Start date Start date
D

Darrell Lankford

Is it anyway to have the page setup for the footer, so when you print,
it adds to the previous page in the workbook? For example: You have 3
pages on Sheet1 & 3 pages on Sheet2. Instead of each page having a
footer with page# 1 - 3, you can get the 3 pages on Sheet1 to have 1 –
3 and Sheet2 would have footer pages 4 - 6.
 
After further research, I'll answer my own question:

Go to Page setup and enter &[page] on footer of each page in workbook.
Select File, Print, & select Entire workbook.
When you print, the page#'s will be 1 - 6.

I'll try to post better questions next time.
 
Back
Top