Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Gradient Background Excel 03

Status
Not open for further replies.

chasethewind

Technical User
Oct 29, 2004
63
0
0
US
Hello,

I would like to have a gradient background for my spreadsheet. I can create a shape or text box with one, however I cannot select the cells underneath the shape/text box. Does anyone have any ideas how this can be accomplished?

Thanks,
 


Hi,

Are you using Fomat > Sheet > Background...?

I can select any cell.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Create a shape box as large at you need for your background and set your gradient.
With the shape box selected, hold your shift key and go to Edit and choose Copy Picture... I used the default settings of Screen and Picture.
Paste the image into your favorite graphics program (like IrfanView) and save the file.
Back in Excel, delete the shape box.
Go to Format / Sheet> Background...
File the file you created, Click [Insert]



Mike
 
That should work great. However, I do not want the background printable, only visual. (lots of ink)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top