• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Putting a drop shadow around a cell range in Excel 2010

J

John Carney

New Member
There seems to be a solution on how to do this in an earlier post, but I don't understand it:
"Take a look at Insert > Shapes, then when you draw around a range a whole new tab opens called Drawing Tools where you can then change format, shapes, styles etc. Oooh and also add Shape Effects ie. Shadows & 3D"

It seems to suggest that you can in fact "draw around a range" but when I open the Shapes tab under the Insert menu, all I can do is draw a shape. I can give that shape a shadow and try to make it fit my range (e.g., N18:Q27) exactly. But when I remove the fill so that I can see the data in my range, the shadow shows inside the left and top of the shape as well as outside the right and the bottom.

Is it possible to do what you could do in Excel 2003, where you could get a proper drop shadow (right and bottom only) around a range. If so, how?

Thanks,
John
 
Shapes do not fit a cell they float over the cells/range. Could you upload so we can see what you need
 
Hi, John Carney!
I agree with b(ut)ob(ut)hc regarding f&f (fitting and floating). But maybe you're referring to this:
Go to Insert tab, Ilustrations group (or however it's called, the 2nd one, after Tables and before Graphics / Charts), Shapes icon, and select the simplest Rectangle.
Then click on the added shape to select it, right click on it and in the contextual menu click on Size And Properties.
Go to the Shadow submenu, 4th entry, and in the right panel click on Predefined (or so) and you'll find all the available combinations.
Is that what you were looking for?
Regards!
 
Thank you both for responding. The problem is that when I remove the fill from the shape, the shadow shows inside the border on the top and the left which defeats the whole point. Please look at the attached workbook to see what I mean.

This is not a super big deal but I'm hoping there is a way to do this.

Thanks,
John
 

Attachments

Hi, John Carney!
Sorry I can't help you further but I don't find a way to do what you want.
Regards!
 
It still has the internal shadow on the top and the left so I can't use it for now, but it's really cool and I can't wait to use it somewhere else. I have a feeling that what I want can no longer be done in Excel. Thanks, bobhc!
 
You must log in or register to reply here.
Back
Top