View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AnimalMagic AnimalMagic is offline
external usenet poster
 
Posts: 20
Default inserting page numbers into a column heading cell

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.