I know how to get the page numbering in a custom header like you said, but
I'd like to get the same result in a cell that is in a Print Title column
that prints on the top of each page rather than the standard header. [I do
not know how to use VBA]
Thank you for your response.

"AnimalMagic" wrote:

On Tue, 7 Apr 2009 19:51:01 -0700, compdinosaur
wrote:

I have a worksheet with a column heading cell with the words "Page Number".
I would like to be able to insert the automatic page number here when the
page prints. I tried
"Page Number &[Page]" , but this just printed literally.
[I am a newbie]


In the print setup, headers tab, choose custom header, and place the
&[Page] command in there. You can place spaces after it to space it in
from the right edge,and you adjust the header placement to change its
vertical placement.