ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Workbook Page Numbers (https://www.excelbanter.com/excel-programming/443459-workbook-page-numbers.html)

Darrell Lankford

Workbook Page Numbers
 
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

Workbook Page Numbers
 
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.


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com