I would like to start at page 5 in my spread sheet. How can I change the page
number in my footer to start at page 5?
--
THEDON

FilePage setupPage tabFirst page number (bottom of the window): enter 5

Default is 'Auto'

If this post helps click Yes
---------------
Jacob Skaria


"The Don" wrote:

I would like to start at page 5 in my spread sheet. How can I change the page
number in my footer to start at page 5?
--
THEDON

hi jacob,

tks for your reply below. just one more problem.
if u use the solution suggested by you, it is giving footer as "5 of 1"
doesn't it look odd. ??
suggest correction/s, if any

tks in advances

"Jacob Skaria" wrote:

FilePage setupPage tabFirst page number (bottom of the window): enter 5

Default is 'Auto'

If this post helps click Yes
---------------
Jacob Skaria


"The Don" wrote:

I would like to start at page 5 in my spread sheet. How can I change the page
number in my footer to start at page 5?
--
THEDON

Sounds like you have only one page and Header settings are Page x of y

Change your Header settings to just Page


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, YESHWANT JOSHI
wrote:

hi jacob,

tks for your reply below. just one more problem.
if u use the solution suggested by you, it is giving footer as "5 of 1"
doesn't it look odd. ??
suggest correction/s, if any

tks in advances

"Jacob Skaria" wrote:

FilePage setupPage tabFirst page number (bottom of the window): enter 5

Default is 'Auto'

If this post helps click Yes
---------------
Jacob Skaria


"The Don" wrote:

I would like to start at page 5 in my spread sheet. How can I change the page
number in my footer to start at page 5?
--
THEDON

HI GORD,

it's not the case. if i start the number from 5 and have 3 sheets to print,
it will show footer as 5 of 3, 6 of 3 and 7 of 3 resp.

any guess / correction ??

"Gord Dibben" wrote:

Sounds like you have only one page and Header settings are Page x of y

Change your Header settings to just Page


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, YESHWANT JOSHI
wrote:

hi jacob,

tks for your reply below. just one more problem.
if u use the solution suggested by you, it is giving footer as "5 of 1"
doesn't it look odd. ??
suggest correction/s, if any

tks in advances

"Jacob Skaria" wrote:

FilePage setupPage tabFirst page number (bottom of the window): enter 5

Default is 'Auto'

If this post helps click Yes
---------------
Jacob Skaria


"The Don" wrote:

I would like to start at page 5 in my spread sheet. How can I change the page
number in my footer to start at page 5?
--
THEDON

If you have only 3 pages what else would you expect to see if you start at
page 5?

Don't use the Page 1 of ? setting.

ViewHeaders and FootersFooter. Select Page 1

Then you will get Page 5, Page 6, Page 7


Gord

On Thu, 6 Aug 2009 11:10:04 -0700, YESHWANT JOSHI
wrote:

HI GORD,

it's not the case. if i start the number from 5 and have 3 sheets to print,
it will show footer as 5 of 3, 6 of 3 and 7 of 3 resp.

any guess / correction ??

"Gord Dibben" wrote:

Sounds like you have only one page and Header settings are Page x of y

Change your Header settings to just Page


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, YESHWANT JOSHI
wrote:

hi jacob,

tks for your reply below. just one more problem.
if u use the solution suggested by you, it is giving footer as "5 of 1"
doesn't it look odd. ??
suggest correction/s, if any

tks in advances

"Jacob Skaria" wrote:

FilePage setupPage tabFirst page number (bottom of the window): enter 5

Default is 'Auto'

If this post helps click Yes
---------------
Jacob Skaria


"The Don" wrote:

I would like to start at page 5 in my spread sheet. How can I change the page
number in my footer to start at page 5?
--
THEDON