[mso] Re: Gradient Shading in Excel
- From: "Michele Wong" <michele@xxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 9 Oct 2003 13:16:29 -0700
I had a question about gradient shading cells in excel and received an
answer, but now I have a new problem. I have prepared the shaded cells in
excel, but when I go to copy another excel table and paste it in the
shaded area, I lose all my data. I try to bring it forward, bring it to
the front and even send the shaded cells to the back, but nothing works. I
end up having to type the data by hand into each cell. Is there a better
way to do this? I will have to generate this table every two weeks.
Thanks,
Michele B. Wong
Reliable Cyber Solutions, LLC
"We're only a click away!"
http://www.reliablecyber.com
michele@xxxxxxxxxxxxxxxxx
425.488.8078 phone
206.683.0624 mobile
775.245.3291 fax
<snip>
The easy way to do this is to start by making a rectangular autoshape
(make sure you have the drawing toolbar up.) The hit the arrow next to the
fill icon, amd choose fill effects. Set your gradient effect.
Now, send to graphic to the back layer so that the worksheet text shows on
top of it. (Draw - order - send to back) Resize the rectangle so it goes
under your full table.
<snip>
<snip>
I know how to shade cells in excel so that they are a particular color
(blue, green, pink, etc) but I was wondering if it's possible to have
shading with a gradient effect like you can in word when you use the paint
bucket in the drawing toolbar? You can do this to rectangles, squares,
autoshapes, etc. I want to create a gradient effect in a table of excel
data.
<snip>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
