Other way out is you can hard code the footer by simply adding the text "1 of
1" in the footer option in page setup.

click yes below, if it helps


"Té" wrote:

I have 4 worksheets in my workbook. When I go to print and choose the entire
workbook the print preview reads page 1 of 4 (referring to the whole book).
How can I set it up where it reads page 1 of 1 on each sheet, without
printing each sheet individually. So far sheets 2-4 it reads page 1 of 1
because they are separate sheets even though they're in a workbook together.