![]() |
Custom Page numbers in the footers
This is kinda long so bear with me...
I need to place a custom page number footer in my worksheet at the break. It is one long worksheet that starts as 17 pages and can grow/shrink depending on the proposal. My problem is that my user insists on numbering by section. So the numbers go 1,2,3,4,5,6a,6b,6c,6d,6e,6f,7 ...instead of 1-17. Is it possible to automatically assign a page number in the footer or to manually footer a master so that the numbers stay with the page? (If that page is deleted so is the page number.) e.g. 1,2,3,5,6a,6b,6d,6f,7...etc |
Custom Page numbers in the footers
Someone that works more with page breaks and setting up footers MAY come
along and provide a method, but I don't know of a way to do this on a single worksheet. I believe you'd be better off, and the whole thing would be more manageable, if you had separate worksheets for each section (especially the 'a', 'b', 'c' areas like 6a, 6b, 6c etc). One alternative would be to simply use rows on the sheet as the footers and put the appropriate page numbers in a cell manually ahead of time along with page breaks down the sheet. "outsol" wrote: This is kinda long so bear with me... I need to place a custom page number footer in my worksheet at the break. It is one long worksheet that starts as 17 pages and can grow/shrink depending on the proposal. My problem is that my user insists on numbering by section. So the numbers go 1,2,3,4,5,6a,6b,6c,6d,6e,6f,7 ...instead of 1-17. Is it possible to automatically assign a page number in the footer or to manually footer a master so that the numbers stay with the page? (If that page is deleted so is the page number.) e.g. 1,2,3,5,6a,6b,6d,6f,7...etc |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com