How to Reset Excel Page Numbers for Each Worksheet When Printing

Hold down the Ctrl key and click the worksheet tabs at the bottom to select the multiple sheets you want to print.

Navigate to the Page Layout tab on the ribbon and click the small Page Setup dialog box launcher arrow in the bottom-right corner of the Page Setup group.

On the Page tab of the dialog box, locate the 'First page number' field at the bottom. Delete 'Auto' and type '1'.

Click OK to save your changes. You can now proceed to print your selected worksheets.

Click on the tab of the first worksheet you wish to print. Ensure no other sheets are selected.

Go to File > Print, verify the print preview to ensure the total page count is correct for this sheet alone, and click Print.

Select the next worksheet and repeat the print process until all necessary sheets are printed.

Use Print Preview on each worksheet individually to determine exactly how many pages it contains.

Go to the Insert tab, click Text, and select Header & Footer.

Instead of inserting the 'Number of Pages' element (&[Pages]), manually type the total number. For example, insert the Page Number element, then type 'of 3' manually (e.g., 'Page &[Page] of 3').

Remember that if the data changes and the worksheet grows or shrinks, you must manually update these hard-coded totals.