Page Numbers

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
Lets say I have a spreadsheet that prints on 100 pages. If I add Page &[Page] of &[Pages] to the footer the first page will have "Page 1 of 100" and so on till the end of printing. But lets say I make a correction to page 30 and only want that page to print, when I do. It will read Page 1 of 1.

How could I get it to read page 30 of 100?

Thanks Parra
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
This is kind of a modified note on what you want to do:

***********
Specifying the Beginning Page Number in Excel
If you intend to insert your printed output into another report, you may want to specify a beginning page number so that the pages collate correctly as you insert them into the report. To do so, follow these steps:
1. Choose the File, Page Setup command.
2. Click the Page tab of the Page Setup dialog box.
3. Specify a page number for the first page in the First Page Number text box. The default option is set to Auto, which starts numbering at page 1.
4. Click OK to close the Page Setup dialog box.
**************


Taken from an "Excel for Dummies" Email.


(y)
 

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
"Taken from an "Excel for Dummies" Email" we'll what can I say...What a way to start off the week. Its always the the simple things that are the hardest.

Thanks

Parra
 

Barrie Davidson

MrExcel MVP
Joined
Feb 10, 2002
Messages
2,330
Another option is to select the entire print range, and then print only page 30. At the print message box, there is an area to select a specific page range. Select page 30 to page 30.

Regards,
 

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
Well, It did seem that the Excel for Dummies email had the info required :)

Just trying to help.

I'm stuck in Trend Analysis hell, and I took time out to water my over-heated cerebellum :rolleyes:



(y)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,327
Messages
5,769,460
Members
425,550
Latest member
Bonebeast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top