Sequential Page Numbers Across Entire Workbook

[termeric]

Hello, I set up my footer with page numbers and want them to continue sequentially when I print out multiple pages. I shift selected all tabs when I applied the page numbers, and also when I go into print preview, but still see the numbers reset to 1 on each work sheet. I was looking at the thread below which says that it should be working, so I think I must be missing something here. any thoughts on what I might be doing wrong?


https://www.mrexcel.com/forum/excel-questions/938857-sequential-page-numbers-multiple-sheets.html

 

[yky]

I shift-selected all sheets and set the page number. In print preview, the page numbers were sequential, from 1 to 22. I'm using Excel 2010.