Changing page numbers to start at a number other than 1

T

The Don

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?
 
J

Jacob Skaria

File>Page setup>Page tab>First page number (bottom of the window): enter 5

Default is 'Auto'

If this post helps click Yes
 
Y

YESHWANT JOSHI

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
 
G

Gord Dibben

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
 
Y

YESHWANT JOSHI

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 ??
 
G

Gord Dibben

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.

View>Headers and Footers>Footer. Select Page 1

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


Gord
 
Top