Missing Drawing Toolbar in Excel 2007

[Guest]

I want to put a shadow on a cell in a spreadsheet and cannot figure out how
to do it. I cannot find the "drawing" toolbar. What am I doing wrong?

 

[Jim Rech]

View, Toolbars, Drawing?

 

[Bernard Liengme]

Have you tried: View | Toolbars and checked Drawing ?
But I am unclear what "put a shadow on a cell" means !
best wishes

 

[Guest]

I clicked on "View" and find I have no toolbar.

 

[Ron de Bruin]

Can't find it now, I never used this in <2007 myself

Shadow in 2007 help tell you about the fill color.

 

[Jim Rech]

Oops, missed the 2007. Shadow on cells went away in 2007. I vaguely
remember that being discussed during the beta test.

 

[Ron de Bruin]

With code you can do it Jim (quick test)

 

[Guest]

In 2007 you'd achieve the shadow effect by Inserting a rectangular shape from
the Insert tab on to your cell.
Draw it the same size as your cell, right on top.
With the shape selected, switch to the Drawing Tools->Format tab and set the
Shape Fill to "no fill".
Then you can experiment with the new graphics -- shadows, glows, blurs, etc.
The shape will conform to your cell, so if you insert or delete rows,
increase/decrease cell size, etc. the shape will change as well (so you don't
need to keep manually adjusting it)

 

[Guest]

Thank you! Thank you! Thank you! It worked as you said.

 

[Ron de Bruin]

Hi Renee

What do you think of this thread
"Default a workbook to save as a xlsm (macro-enabled) in 2007"

I think a xltm template must default to xlsm when you save

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm