Select a sheet and right-click on the tab and "Select all sheets"

Go to ViewHeaders and footers.

Select from the drop-down "Page 1 of ?"

OK out.

Right-click and "ungroup sheets".

FilePrintPrint WhatEntire Workbook


Gord Dibben MS Excel MVP

On Wed, 27 Sep 2006 11:02:02 -0700, Becot
wrote:

I have an Excel spreadsheet that has 3 separate worksheets in it.

The documents will all be printed together as one large document and I would
like consecutive page numbering throughout the document. So far, all I can
get is page 1-3 of the first worksheet, page 1-4 of the second, etc.

Any advice? Can this be done?