insert auto text

  • Thread starter Thread starter Linda
  • Start date Start date
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]
 
View>Header and Footer

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


Gord Dibben MS Excel MVP
 
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 said:
Kevin

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


Gord

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]
Click to expand...
Click to expand...
 
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
 
Back
Top