Page Numbers In Different Pages

  • Thread starter Thread starter UT
  • Start date Start date
U

UT

I have several page breaks in a worksheet. Is there a way to insert a new
page number (not consective numbering) for every page in the footer or to
print every page with page number starting from 1?

Any help is appreciated.
 
Your description does not compute with me.

You want non-consecutive numbering starting with 1

Where do you want to go from 1?


Gord Dibben MS Excel MVP
 
When I print the worksheet each page break should start with a fresh page
number.
Example-- Page Break 1 should print - page 1, page 2....
Page Break 2 should print - page 1, page 2....

Any ideas how this can be done? Thanks!
 
I'm still not understanding<g>

A page break is where you designate a new page to be printed.

Like page 1............break..........page 2.........break...........page 3

You cannot have two pages within one page break.

Ergo.....you cannot have two page numbers within the same page.

What would you really like to have your output look like given the constraints
above?

If you want Page 1 on every page, print one page at a time.


Gord
 
Ok, I have horizontal page breaks on my worksheet. So, my sheet looks like
this...

Break 1 - Page 1, Page 2, Page 3
Break 2 - Page 4, Page 5, Page 6
and so on..........

So when I print, Break 1 that Page 1 to Page 3, it should print with page
numbers, numbered 1, 2, 3

Then when I print Break 2 that is Page 4 to Page 6, it should print with
page numbers, numbered 1, 2, 3

Hope I have explained better now. Thanks!
 
Only way I can see is to designate named printranges as Break1, Break2 etc.

Have horizontal pagebreaks within these ranges.

Print one range at a time.

i.e. Break1 range is A1:K120

Horizontal pagebreaks at row 40 and 80 will produce 3 pages which will be page1,
page2, page3

Same for Break2 range.


Gord
 
Back
Top