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?

View, Toolbars, Drawing?

--
Jim
"gjpundsack" wrote in message
...
|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?

Have you tried: View | Toolbars and checked Drawing ?
But I am unclear what "put a shadow on a cell" means !
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"gjpundsack" wrote in message
...
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?

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

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

--
Jim
"gjpundsack" wrote in message
...
|I clicked on "View" and find I have no toolbar.
|
|

With code you can do it Jim (quick test)

--

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


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

--
Jim
"gjpundsack" wrote in message
...
|I clicked on "View" and find I have no toolbar.
|
|

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

Shadow in 2007 help tell you about the fill color.


--

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


"gjpundsack" wrote in message ...
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?

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)
--
-----------------------------------------
This posting is provided "as is" with no warranties, and confers no rights.



"gjpundsack" wrote:

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?

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

"Renee [MSFT]" wrote:

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)
--
-----------------------------------------
This posting is provided "as is" with no warranties, and confers no rights.



"gjpundsack" wrote:

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?

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


"Renee [MSFT]" wrote in message ...
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)
--
-----------------------------------------
This posting is provided "as is" with no warranties, and confers no rights.



"gjpundsack" wrote:

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?