MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Custom Border/Backgrounds


Posted by Jamal on February 23, 2001 6:39 AM

I would like to create a custom border for my
Excel Spreadsheet report. How would I go about creating one and applying it?

My second question is about applying pictures in the
background. I have a picture (I think it is a bmp or
jpeg.) I want this to be in the background with the report OVERLAYING it. I pasted the picture on a blank sheet and then copied the text as a picture over it. This works, but it is time consuming and requires a lot of editing and resizing. How can I quickly and easily choose a picture in the background of any sheet, make it fit to the size of one full page, and allow my report to appear LEGIBLY in the FOREGROUND without making the text a picture? I could apply a picture to any page that already has data.

I would appreciate your help,

Jamal


Posted by Dave Hawley on February 23, 2001 6:50 AM


Hi Jamal

For your custom border, select your table and go to Format>Cells>Border.

For background. Go to Format>Sheet>Background.

Dave
OzGrid Business Applications

Posted by Jamal on February 23, 2001 7:22 AM


Thank you very much Dave,

However, these are PRESET borders, How would I
make my OWN CUSTOM borders? How do I also make the background PRINT?

Jamal


Posted by Dave Hawley on February 23, 2001 7:39 AM


Jamal, for your printing problem go here.

http://www.zdnet.com/pcmag/stories/solutions/0,8224,2394127,00.html


For your custom borders you will be very limited to what you can achieve in Excel. You can try using lines from the Drawing toolbar, but you would be better of doing this in Word, Powerpoint, Frontpage etc.

Dave

OzGrid Business Applications

Posted by Jamal on February 23, 2001 8:57 AM

Thanks Dave,

You great knowledge is very helpful. Can you tell
me how to PRINT the background to the printer.

Thanks,

Jamal