| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increment page number in a cell of worksheet
I have a problem regarding page numbers in a worksheet. The position of page
number in the cell is such that page number cannot be provided through header or footer. Can you guide me about how can I increment page numbers in a cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to increment page number in a cell of worksheet
This is a very unreliable workaround.
Declare col. "A" to be an Helper-Column. In Cell A1 type the following formula and copy down to the end of your data. Col. A Cells should, now, present the page number. Pull out one of each, in a "page", to another column in order to present the page number. You may fine-tune, the formula, by slightly changing the 55 *** Hide column "A" *** =IF(MOD(CELL("row",B1),55)=0,CELL("row",B1)/55,INT(CELL("row",B1)/55)+1) Micky "Zubair" wrote: I have a problem regarding page numbers in a worksheet. The position of page number in the cell is such that page number cannot be provided through header or footer. Can you guide me about how can I increment page numbers in a cell. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to increment page number in a cell of worksheet
My worksheet is such that there is a panel in the top, that contains a cell
in the right in cell "BY3". Page number is incrementing during printing as the panel is fixed and the worksheet is going on to page 1, 2, 3...... "מיכאל (מיקי) אבידן" wrote: This is a very unreliable workaround. Declare col. "A" to be an Helper-Column. In Cell A1 type the following formula and copy down to the end of your data. Col. A Cells should, now, present the page number. Pull out one of each, in a "page", to another column in order to present the page number. You may fine-tune, the formula, by slightly changing the 55 *** Hide column "A" *** =IF(MOD(CELL("row",B1),55)=0,CELL("row",B1)/55,INT(CELL("row",B1)/55)+1) Micky "Zubair" wrote: I have a problem regarding page numbers in a worksheet. The position of page number in the cell is such that page number cannot be provided through header or footer. Can you guide me about how can I increment page numbers in a cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Increment a number upon a match in an adjacent cell | Excel Worksheet Functions | |||
| Increment a number in a cell for each page printed | Excel Discussion (Misc queries) | |||
| number cell increment +1 when dragging down box | Excel Worksheet Functions | |||
| how to auto increment a number each time i open the worksheet | Excel Worksheet Functions | |||
| How do I automatically increment worksheet number when pasting a . | Excel Worksheet Functions | |||
Hybrid Mode
