How do I insert page numbers on an Excel report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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,
 
Back
Top