How to increment page number in a cell of worksheet

  • Thread starter Thread starter Zubair
  • Start date Start date
Z

Zubair

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.
 
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
 
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......
 
Back
Top