How do I insert page numbers on an Excel report.

  • Thread starter Inserting Page Numbers
  • Start date
I

Inserting Page Numbers

Haven't got used to the new Excel so I having problems learning how to use
it. Can't seem to figure out our to insert page numbers, i.e. Page 1 of 12,
Page 2 of 12, etc.
 
G

George Nicholson

File>PageSetup>Header/Footer>CustomFooter

In the resulting dialog there are a number of icons. Click the ones with #
and ##.
You should now see:
&[Page]&[Pages]
Change this to read:
&[Page] of &[Pages]

HTH,
 
Top