ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Easy question? Page numbers (https://www.excelbanter.com/excel-discussion-misc-queries/68640-easy-question-page-numbers.html)

ATC

Easy question? Page numbers
 

Hello folks, this should be easy...how do I print sequential page
numbers when I print an entire workbook. In other words, if sheet1 ends
at page 3, I want the first page of sheet2 to print as page 4 and
continuing sequentially through the rest of the worksheets. How do I do
this? This has to be easy. I feel stupid for asking, but I can't figure
it out.

Thanks in advance!


--
ATC
------------------------------------------------------------------------
ATC's Profile: http://www.excelforum.com/member.php...o&userid=24747
View this thread: http://www.excelforum.com/showthread...hreadid=507083


Debra Dalgleish

Easy question? Page numbers
 
Add a footer to each sheet, with the page number in the footer.
Select all the sheets that you want to print, and click the Print
Preview button.
The pages should be numbered sequentially.
If the page numbering looks okay, click the Print button.

ATC wrote:
Hello folks, this should be easy...how do I print sequential page
numbers when I print an entire workbook. In other words, if sheet1 ends
at page 3, I want the first page of sheet2 to print as page 4 and
continuing sequentially through the rest of the worksheets. How do I do
this? This has to be easy. I feel stupid for asking, but I can't figure
it out.

Thanks in advance!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



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

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