Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - print workbook with page numbers on bottom

Status
Not open for further replies.

lenebene

Programmer
Sep 24, 2002
15
US
I can't print out a workbook with all the page numbers... Can anyone tell me how to do this?

Thanks!
 
Click File, Page Setup. Click Header/Footer Tab. Click Custom Footer. In right, middle, or left window(depending on where you want the page # to show up), left click in it so your cursor is blinking in it. Click the icon above with the # sign in it. Click OK twice. That will put the page # on each of your pages.
 
If all your worksheets are setup to print page numbers, then all you need to do is go to File, Print, under Print what select Entire workbook. The worksheets will print in sequence with page numbers also in sequence.

Member AAA - Abolish Abused Abbreviations
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top