Insert Page Number in a cell

Is there any possibility that i can put page numbers automatically in a
worksheet cell

Well, you can determine the number of rows per page, then type 1 in , say,
cell A40 then in cell A80, enter = A40+1 and copy down that way... Otherwise,
you're looking at using headers or possibly some sort of macro...

"Iffi" wrote:

> Is there any possibility that i can put page numbers automatically in a
> worksheet cell

Hi,

There is nothing built-into Excel to do that. The problem is that as you
change the scaling factor in the page setup area this would change. So if
cell F1 was the top left corner of page 2, where you wanted the page number
while scaling was set 100% it might be part of page 1 at a different scaling
factor. So a different cell might be where the page number should now go.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Iffi" wrote:

> Is there any possibility that i can put page numbers automatically in a
> worksheet cell