How to print page numbers

Hi

I have a workbook with over 40 sheets, I have set up the print area on each sheet.

I can printout the entire workbook but cannot see how to get the page numbers to print.

I have looked in the help section but do not understand what it is telling me to do.

Can someone please assist me.

Thanks

Daniel

You can use this AddIns to print multiple sheets (by select in list).
See the below file.

Originally Posted by Sambo kid

use the header and footer section under view.

Hi

I cannot see any "header and footer" section under view on the ribbon menu,
perhaps I am looking in the wrong place.

Cheers

Daniel