Different footer in the same excel worksheet?

Different footer in the same excel worksheet?

Didn't find your answer?

is this possible - I want to start with page 21 & go to page 33? Thanks in advance

Replies (8)

Please login or register to join the discussion.

By johngroganjga
23rd May 2014 11:47

There is a page number (and indeed number of pages) function.  So the basic page numbering is quite easy.  But if you are asking how to start the page counter at 21, then I'm not sure.

Thanks (0)
avatar
By Richard Willis
23rd May 2014 15:23

In the 'Page' tab

of the page setup dropdown there is a 'First Page Number' box, auto by default, in which you can type an alternative.

Thanks (0)
avatar
By Richard Willis
23rd May 2014 15:26

Strangely,

if you use the 'Number of pages' feature it appears to say 'Page 21 of 1' for the first page!

Thanks (0)
Stepurhan
By stepurhan
23rd May 2014 17:31

Cannot use Page X of Y

You cannot use "Page X of Y" in conjunction with a different starting number. Logically, this is because Excel no longer knows how many total pages there are. Under Auto numbering starting from 1, it calculates the total number of pages.

"Page X" on its own will work though, which is presumably what the OP wants.

Thanks (0)
avatar
By Richard Willis
23rd May 2014 18:08

Lazy programming!

Not very hard to make the total number of pages = total + (start-1).  It must know the total to do it starting from1.

Thanks (0)
Stepurhan
By stepurhan
24th May 2014 08:40

Not necessarily

If you are starting at page 20, there must be 19 pages coming from somewhere else before that. There may be a load of pages coming from somewhere else afterwards as well. Excel has no way of knowing.

Not offering the option to put a total number of pages in to get around this is slightly lazy programming. Possibly they think it is too rare to offer as a standard feature.

Thanks (0)
Scalloway Castle
By scalloway
24th May 2014 18:12

If you know the total number of pages

then it is possible to enter the number of total pages manually.

Thanks (0)
avatar
By maxmillion
25th May 2014 00:47

Make as if you want to print the whole file using Ctrl P, or preview first.

Then on the print screen you have the opportunity to print the whole range or just selected pages.

I think if you enter in the box 21-28 or 19, 21, 25-28 (to choose only specific pages), then it should print just those pages but with the correct numbering.

-M

 

Thanks (0)