Page Numbers as Background
 

How do you create the page number to be in the backgound of a worksheet? Not
as a header or footer, but large and in the center of a sheet.

Thanks,
Karen

Karen, try view, page break preview
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"KG" wrote in message
...
How do you create the page number to be in the backgound of a worksheet?
Not
as a header or footer, but large and in the center of a sheet.

Thanks,
Karen

Thanks, will it print if you select print from the Page Break View? If not
how do you get it to print?

Karen

"Paul B" wrote:

Karen, try view, page break preview
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"KG" wrote in message
...
How do you create the page number to be in the backgound of a worksheet?
Not
as a header or footer, but large and in the center of a sheet.

Thanks,
Karen

Karen, no this will not print, don't know of and easy way to do it, have a
look here for some ways

http://redirx.com/?36s0
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"KG" wrote in message
...
Thanks, will it print if you select print from the Page Break View? If
not
how do you get it to print?

Karen

"Paul B" wrote:

Karen, try view, page break preview
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"KG" wrote in message
...
How do you create the page number to be in the backgound of a
worksheet?
Not
as a header or footer, but large and in the center of a sheet.

Thanks,
Karen

get a cell and , format the properties to put a page number tag to it,
put a size what ever you like may be add some transparency to it that
should do it,

My other option but you have to be tricky is moving your header to the
middle or, adding a text box as a background.

Have fun !!! Remember have to get tricky


--
MDOTJR

IT
------------------------------------------------------------------------
MDOTJR's Profile: http://www.excelforum.com/member.php...o&userid=27332
View this thread: http://www.excelforum.com/showthread...hreadid=468221