Prev Previous Post   Next Post Next
  #1   Report Post  
hogon
 
Posts: n/a
Default Chapter numbers

My spreadsheet/workbook consists of approx. 80 worksheets. Each worksheet
should be considered a page. I have inserted sequential page numbers in the
footer. However, is there a way I can insert a chapter number before each
page number, i.e., 1-1, 1-2, 1-3, etc? And if I can be even more greedy, is
there a way I can "break" the chapter numbers within my workbook, so that the
first 40 pages will paginate as 1-2, 1-2, 1-3, etc., and the last 40 pages
will paginate as 2-1, 2-2, 2-3, etc.?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
Converting Numbers to Text properly Shirley Munro Excel Discussion (Misc queries) 1 February 16th 05 03:01 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"