Sorry guys, still not working.

first and second worksheet say "1 of 54" the thrid starts "1 of 54, then 2
and so on.


--
thomp


"Gord Dibben" wrote:

Right-click on a sheet tab and "Select all sheets"

Add your footer of page 1 of ?

Ungroup the sheets.

Now try the entire workbook and print preview.


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 08:03:01 -0700, ThomP
wrote:

I am helping out a friend here, and I am stumped.

Want to print a workbook, numbering all the printed sheets, comes to 54
pages. Well after selecting the entire workbook and adding the "Page 1 of ?"
to the footer, it is not working, each worksheets starts with "1 of 54".

Any ideas? or help?