Page numbering different pages on the same worksheet

Copper Contributor
I have 4 pages in the same worksheet or tab. I have the pages arranged horizontally across in a row. I want to number the pages like "Page 2 of 4". But the numbers keep coming out wrong. I made the first page separate and manually typed in Page 1 of 4 but I can't get page 3 and 4 to say 3 and 4. And every time I change the footer to say Page 3 of 4 it then repeats on the second page. Any help or tips would be appreciated.
1 Reply

@CW41_5 

Sorry, I din't catch why

Page &[Page] of &[Pages]

doesn't work with you. And in Page Setup you may check different footer for the first page.