Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a 12 page pricelist. Recently we made changes to the last 4
pages of this sheet. I am not getting ready to have the last 4 pages printed and sent to my customers so that they can simply replace the last 4 pages, leaving the first 8 in tact. I copied the last 4 pages into a new book, and need the page numbers to read 9 of 12, 10 of 12 ect. However, because the pages are in a new book I can only figure out how to have it say 1 of 4, 2 of 4 and so on. Basically, I need to change the footer to read 9 of 12, 10 of 12, 11 of 12 and 12 of 12, but this is only a 4 page sheet. Any thoughts? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Nevermind, I found it...thanks anyway.
|
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Custom Footer:
in the section for the footer where you want the page number, hit the page icon which should insert &[Page] and immediately type +8 of 12 and voila! you're done. So the entry might look something like: &[Page]+8 of 12 "ChuckF" wrote: I have a 12 page pricelist. Recently we made changes to the last 4 pages of this sheet. I am not getting ready to have the last 4 pages printed and sent to my customers so that they can simply replace the last 4 pages, leaving the first 8 in tact. I copied the last 4 pages into a new book, and need the page numbers to read 9 of 12, 10 of 12 ect. However, because the pages are in a new book I can only figure out how to have it say 1 of 4, 2 of 4 and so on. Basically, I need to change the footer to read 9 of 12, 10 of 12, 11 of 12 and 12 of 12, but this is only a 4 page sheet. Any thoughts? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto-Numbering Occurrences Question | Excel Worksheet Functions | |||
Auto numbering with letters - re-posting question from above | Excel Discussion (Misc queries) | |||
Page numbering question | Excel Discussion (Misc queries) | |||
Auto page numbering for several worksheets | Excel Worksheet Functions | |||
AUTO PAGE NUMBERING DIFFERENTLY FOR A WORKBOOK | Excel Worksheet Functions |