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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
Jay at
http://www.mdotutorials.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks