View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Johnny Raisinger
 
Posts: n/a
Default Changing number sequence on different pages

I have an excel spreadsheet that is 100 pages long. I would like for page 11
to say page 1 of 1, page 12 to say Page 1 of 2, and so on and so on. At page
41 I would like to start a new numbering sequence again so that it is Page 1
of 1 until the end which would be Page 60 of 60.
Is there a way to do this. I tried all kinds of ways and have failed except
to create multiple worksheet tabs so that those selected pages are in those
worksheets.