Sequential page numbers in multiple sheets

[Mihael]

Hi!

I have multiple sheets and when I put the page numbers, every page is page number one.

How do I make it sequential with all the worksheets?

I am using Excel 2010.

 

[Comfy]

Put this in your footer


&[Page] of &[Pages]

 

[Mihael]

Hey, it still shows only one page. But only now it shows 1 of 1

 

[Comfy]

It will until you select all the sheets for printing.

 

[Mihael]

I got it.

I converted it in PDF and then it is okay, but how can I let it count from the second sheet, because my first page is a cover page.

 

[Comfy]

For the cover page change the footer text colour to white, see if that works.

 

[Mihael]

Thanks Comfy!