ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Page numbers on ea WS for entire workbooj (https://www.excelbanter.com/excel-worksheet-functions/212018-page-numbers-ea-ws-entire-workbooj.html)

Swimmom

Page numbers on ea WS for entire workbooj
 
I canno figure out how to insert page numbers on each worksheet so that when
I print the entire workbook, each worksheet prints the page number it is
within the workbook as a whole. All I can find is how to insert a page
number on each individual WS, which will not work for me on this project.
Any help would be appreciated!

Swimmom

Page numbers on ea WS for entire workbooj
 
I am soory for all of the typos, I typed this holding and feeding a baby.
THKU!

"Swimmom" wrote:

I canno figure out how to insert page numbers on each worksheet so that when
I print the entire workbook, each worksheet prints the page number it is
within the workbook as a whole. All I can find is how to insert a page
number on each individual WS, which will not work for me on this project.
Any help would be appreciated!


MyVeryOwnSelf[_2_]

Page numbers on ea WS for entire workbooj
 
I canno figure out how to insert page numbers on each worksheet so
that when I print the entire workbook, each worksheet prints the page
number it is within the workbook as a whole. All I can find is how to
insert a page number on each individual WS, which will not work for me
on this project. Any help would be appreciated!


First select all tabs.

Then use
File Page setup Page
and in the box called "First page number" put
Auto

(I have Excel 2003.)


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

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