View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Worksheet page numbering

To print consecutive page numbers simply select "Entire Workbook".

If you want to print only some sheets with consecutive numbers CTRL + Click
on each sheet you want to print then select "Active Sheet(s)"


Gord Dibben MS Excel MVP

On Sat, 26 Sep 2009 07:55:02 -0700, Curtis
wrote:

I have a workbook with 30+ worksheets and am hoping there is an easy way to
have the page numbers automatically print in order based on the number of
sheets. currently each sheet prints as page 1

thanks

ce