insert auto text
 

how do you insert page 1 of 2 in a footer in excel like you can in word

insert auto text
 

File, Page Setup, Header/Footer, Custom Footer, click the buttons

Linda wrote:

how do you insert page 1 of 2 in a footer in excel like you can in word

insert auto text
 

Click FILE in the menu and select PAGE SETUP. In the PAGE SETUP dialog box,
click the HEADER/FOOTER tab and then click the CUSTOM FOOTER command button.

In either the left/center/right panel type the word "Page" w/o quotes, press
the space bar and click the second command button (going from left to right),
which has a single "+" on it. Then press the spacebar and type the word "of"
followed by a space and then click the third command button (going from left
to right), which has 2 plus signs on it.

Your footer will look like the text below:

Page &[Page] of &[Pages]
--
Kevin Backmann


"Linda" wrote:

how do you insert page 1 of 2 in a footer in excel like you can in word

insert auto text
 

ViewHeader and Footer

Click on the dropdown in Footer and select Page 1 of ?


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 10:13:02 -0800, Linda
wrote:

how do you insert page 1 of 2 in a footer in excel like you can in word

insert auto text
 

Kevin

Why go to Custom Footer when the default footer dropodown will suffice?


Gord

On Thu, 24 Jan 2008 10:51:02 -0800, Kevin B
wrote:

Click FILE in the menu and select PAGE SETUP. In the PAGE SETUP dialog box,
click the HEADER/FOOTER tab and then click the CUSTOM FOOTER command button.

In either the left/center/right panel type the word "Page" w/o quotes, press
the space bar and click the second command button (going from left to right),
which has a single "+" on it. Then press the spacebar and type the word "of"
followed by a space and then click the third command button (going from left
to right), which has 2 plus signs on it.

Your footer will look like the text below:

Page &[Page] of &[Pages]

insert auto text
 

You got me on that one Gord. It was one of my "Ready, fire, aim..." moments.

Thanks for the heads up, it helps me maintain some humility.
--
Kevin Backmann


"Gord Dibben" wrote:

Kevin

Why go to Custom Footer when the default footer dropodown will suffice?


Gord

On Thu, 24 Jan 2008 10:51:02 -0800, Kevin B
wrote:

Click FILE in the menu and select PAGE SETUP. In the PAGE SETUP dialog box,
click the HEADER/FOOTER tab and then click the CUSTOM FOOTER command button.

In either the left/center/right panel type the word "Page" w/o quotes, press
the space bar and click the second command button (going from left to right),
which has a single "+" on it. Then press the spacebar and type the word "of"
followed by a space and then click the third command button (going from left
to right), which has 2 plus signs on it.

Your footer will look like the text below:

Page &[Page] of &[Pages]

insert auto text
 

We all get used to replying with the Custom footer because most people already
know how to pick from the defaults so we tend to forget they are available.


Gord

On Thu, 24 Jan 2008 14:56:53 -0800, Kevin B
wrote:

You got me on that one Gord. It was one of my "Ready, fire, aim..." moments.

Thanks for the heads up, it helps me maintain some humility.