Workbook Page Numbers

[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.

 

[Darrell Lankford]

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.