Insert an Arrow from Draw Toolbar
 

I am a new user and I wish to insert an arrow, from the Draw Toolbar, into a
cell in an Excel worksheet. However, when I click on the arrow button in the
Draw Toolbar the images are all "gray" and I can not highlight the image.
Does this mean that the images are not loaded on my computer? Or, is there
some command to unlock the images? This is an older version of Microsoft
Office and an older computer, if that should matter.

Thank you, for help with this matter.

George

Insert an Arrow from Draw Toolbar
 

Which arrow button are you clicking?

See this screencap:

http://img231.imageshack.us/img231/8...toolbarlz3.jpg

After you click the highlighted button navigate to where you want to draw
the arrow. The cursor will change to a "skinny + sign". Left click and hold,
then drag to draw the arrow. When you relase the left mouse button then the
arrow styles button will be active. Or, you can hover the mouse over the
drawn arrow and when the cursor changes to a "4 point arrow" right click and
you'll get a menu with many formatting options.


--
Biff
Microsoft Excel MVP


"George Rivers" <George wrote in message
...
I am a new user and I wish to insert an arrow, from the Draw Toolbar, into
a
cell in an Excel worksheet. However, when I click on the arrow button in
the
Draw Toolbar the images are all "gray" and I can not highlight the image.
Does this mean that the images are not loaded on my computer? Or, is there
some command to unlock the images? This is an older version of Microsoft
Office and an older computer, if that should matter.

Thank you, for help with this matter.

George

Insert an Arrow from Draw Toolbar
 

1. The worksheet may be protected.

ToolsProtectionUnprotect Sheet

2. You may have more than one sheet selected.

Right-click on any sheet tab and "Ungroup sheets".

3. The workbook may be "shared".

ToolsShare Workbook and uncheck the "Allow changes to be made etc."

BTW.........you cannot "insert" and object into a cell, just lay it on top.


Gord Dibben MS Excel MVP

On Sun, 2 Mar 2008 14:24:00 -0800, George Rivers <George
wrote:

I am a new user and I wish to insert an arrow, from the Draw Toolbar, into a
cell in an Excel worksheet. However, when I click on the arrow button in the
Draw Toolbar the images are all "gray" and I can not highlight the image.
Does this mean that the images are not loaded on my computer? Or, is there
some command to unlock the images? This is an older version of Microsoft
Office and an older computer, if that should matter.

Thank you, for help with this matter.

George

Insert an Arrow from Draw Toolbar
 

hi
if you can see the draw tool bar, they are loaded.
i think you are trying to select arrow style before you drew the arrow.
select the single arrow on the draw tool bar and draw the arrow on the sheet
then slect the arrow style form the arrow style icon.
but i think you will run it a problem anyway. drawn object cannot be put
into a cell. they just float on top on the sheet. and can be moved around
independent of a cell.
if you want the arrow inside the cell, do this....
on the menu bar....
insertsyble
scroll down and select a arrow symble, click incert, click close, press
enter.
there are several styles to pick
another option...
set the font of the cell to wingding3. all of the lower case letter on the
keyboard represent a differnt kind of arrow. experiment with it.

Regards
FSt1

"George Rivers" wrote:

I am a new user and I wish to insert an arrow, from the Draw Toolbar, into a
cell in an Excel worksheet. However, when I click on the arrow button in the
Draw Toolbar the images are all "gray" and I can not highlight the image.
Does this mean that the images are not loaded on my computer? Or, is there
some command to unlock the images? This is an older version of Microsoft
Office and an older computer, if that should matter.

Thank you, for help with this matter.

George

Insert an Arrow from Draw Toolbar
 

Thank you, Thank you, and Thank you again. I was not drawing it first and
really did not know or understand what I was suppose to be doing in the Draw
Toolbar, but the suggestions y'all gave helped me and I have now inserted an
arrow into my program.

Thanks again,

George

"FSt1" wrote:

hi
if you can see the draw tool bar, they are loaded.
i think you are trying to select arrow style before you drew the arrow.
select the single arrow on the draw tool bar and draw the arrow on the sheet
then slect the arrow style form the arrow style icon.
but i think you will run it a problem anyway. drawn object cannot be put
into a cell. they just float on top on the sheet. and can be moved around
independent of a cell.
if you want the arrow inside the cell, do this....
on the menu bar....
insertsyble
scroll down and select a arrow symble, click incert, click close, press
enter.
there are several styles to pick
another option...
set the font of the cell to wingding3. all of the lower case letter on the
keyboard represent a differnt kind of arrow. experiment with it.

Regards
FSt1

"George Rivers" wrote:

I am a new user and I wish to insert an arrow, from the Draw Toolbar, into a
cell in an Excel worksheet. However, when I click on the arrow button in the
Draw Toolbar the images are all "gray" and I can not highlight the image.
Does this mean that the images are not loaded on my computer? Or, is there
some command to unlock the images? This is an older version of Microsoft
Office and an older computer, if that should matter.

Thank you, for help with this matter.

George

Insert an Arrow from Draw Toolbar
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"George Rivers" wrote in message
...
Thank you, Thank you, and Thank you again. I was not drawing it first and
really did not know or understand what I was suppose to be doing in the
Draw
Toolbar, but the suggestions y'all gave helped me and I have now inserted
an
arrow into my program.

Thanks again,

George

"FSt1" wrote:

hi
if you can see the draw tool bar, they are loaded.
i think you are trying to select arrow style before you drew the arrow.
select the single arrow on the draw tool bar and draw the arrow on the
sheet
then slect the arrow style form the arrow style icon.
but i think you will run it a problem anyway. drawn object cannot be put
into a cell. they just float on top on the sheet. and can be moved around
independent of a cell.
if you want the arrow inside the cell, do this....
on the menu bar....
insertsyble
scroll down and select a arrow symble, click incert, click close, press
enter.
there are several styles to pick
another option...
set the font of the cell to wingding3. all of the lower case letter on
the
keyboard represent a differnt kind of arrow. experiment with it.

Regards
FSt1

"George Rivers" wrote:

I am a new user and I wish to insert an arrow, from the Draw Toolbar,
into a
cell in an Excel worksheet. However, when I click on the arrow button
in the
Draw Toolbar the images are all "gray" and I can not highlight the
image.
Does this mean that the images are not loaded on my computer? Or, is
there
some command to unlock the images? This is an older version of
Microsoft
Office and an older computer, if that should matter.

Thank you, for help with this matter.

George