View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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]