Good evening thaimic
It can be done, but it's not standard Excel behaviour and it uses the old XLM macro language that's not longer supported, and is a bit of a fudge really, but here goes :
Go to Formula > Name Manager > New. In Name, enter, say, MyPage.
In Refers To, enter =GET.DOCUMENT(64)
Now in the cell you want to add the page number to enter this formula :
=IF(ISNA(MATCH(ROW(),MyPage)),1,MATCH(ROW(),MyPage)+1)
If you enter page breaks or faff around with the print settings you are going to have to refresh the formulae because they aren't volatile so won't change themselves. It may also be a bit slow in processing (see my opening comments) but it's about the only way ...
HTH
DominicB
