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

On Wed, 18 Jun 2008 10:33:00 -0700, UT wrote:

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.

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!

"Gord Dibben" wrote:

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

On Wed, 18 Jun 2008 10:33:00 -0700, UT wrote:

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.

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

On Sat, 21 Jun 2008 13:54:00 -0700, UT wrote:

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!

"Gord Dibben" wrote:

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

On Wed, 18 Jun 2008 10:33:00 -0700, UT wrote:

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.

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!



"Gord Dibben" wrote:

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

On Sat, 21 Jun 2008 13:54:00 -0700, UT wrote:

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!

"Gord Dibben" wrote:

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

On Wed, 18 Jun 2008 10:33:00 -0700, UT wrote:

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.

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

On Sun, 22 Jun 2008 09:18:01 -0700, UT wrote:

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!



"Gord Dibben" wrote:

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

On Sat, 21 Jun 2008 13:54:00 -0700, UT wrote:

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!

"Gord Dibben" wrote:

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

On Wed, 18 Jun 2008 10:33:00 -0700, UT wrote:

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.