Page numbering

JazzyJen

New Member
Joined
Apr 11, 2002
Messages
23
Okay, this might be an easy one....
Is there any way to start page numbers on a different page (i.e. page 7 will be numbered page 1). I have tried everything and I do
not want to resort to manually putting page numbers directly on the sheet. Help.....
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
How about naming the first 6 pages with one name and the remainder with another. Then, a macro to print the first named range, insert the page # in the footer, print the next named range, and finally, delete the footer in preparation for the next printing.
 
Upvote 0

Forum statistics

Threads
1,195,594
Messages
6,010,625
Members
441,558
Latest member
lambierules

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