ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom Page numbers in the footers (https://www.excelbanter.com/excel-discussion-misc-queries/176882-custom-page-numbers-footers.html)

outsol

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

JLatham

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