Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Large Arrow with Text
I want to create a large arrow big enough to put some text within the outline
of the arrow and insert the text. I've seen examples of this so I know it can be done, but I'm not sure how. Thanks for any help on this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Large Arrow with Text
Activate the Drawing Toolbar, select Block Arrows from the Autoshapes options.
Click on the arrow of choice and draw it on the sheet by holding down the mouse button and dragging diagonally down to the right. You can choose a fill colour at this stage. Click off the arrow then right-click on it and choose Add Text. When the text is added click off then clcik on the arrow. if a rectangle is selected then click the Centre button to centre the Arrow text. Is this helps please click Yes. Peter "dhstein" wrote: I want to create a large arrow big enough to put some text within the outline of the arrow and insert the text. I've seen examples of this so I know it can be done, but I'm not sure how. Thanks for any help on this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Large Arrow with Text
dhstein wrote:
I want to create a large arrow big enough to put some text within the outline of the arrow and insert the text. I've seen examples of this so I know it can be done, but I'm not sure how. Thanks for any help on this. In E2003 (not sure about later versions) the Drawing toolbar has some flexible arrow shapes in which you can add text. Enable the toolbar by right-clicking in an empty space in the toolbar area, make sure Drawing is checked, then look in AutoShapes | Block Arrows. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Large Arrow with Text
I can add the arrow - but there is no option to add text
"Billy Liddel" wrote: Activate the Drawing Toolbar, select Block Arrows from the Autoshapes options. Click on the arrow of choice and draw it on the sheet by holding down the mouse button and dragging diagonally down to the right. You can choose a fill colour at this stage. Click off the arrow then right-click on it and choose Add Text. When the text is added click off then clcik on the arrow. if a rectangle is selected then click the Centre button to centre the Arrow text. Is this helps please click Yes. Peter "dhstein" wrote: I want to create a large arrow big enough to put some text within the outline of the arrow and insert the text. I've seen examples of this so I know it can be done, but I'm not sure how. Thanks for any help on this. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Large Arrow with Text
Just select the shape (so that the selection handles show around it) and
start typing. -- Rick (MVP - Excel) "dhstein" wrote in message ... I can add the arrow - but there is no option to add text "Billy Liddel" wrote: Activate the Drawing Toolbar, select Block Arrows from the Autoshapes options. Click on the arrow of choice and draw it on the sheet by holding down the mouse button and dragging diagonally down to the right. You can choose a fill colour at this stage. Click off the arrow then right-click on it and choose Add Text. When the text is added click off then clcik on the arrow. if a rectangle is selected then click the Centre button to centre the Arrow text. Is this helps please click Yes. Peter "dhstein" wrote: I want to create a large arrow big enough to put some text within the outline of the arrow and insert the text. I've seen examples of this so I know it can be done, but I'm not sure how. Thanks for any help on this. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Large Arrow with Text
Thanks Rick - that worked. Thanks to all who replied to this post.
David "Rick Rothstein" wrote: Just select the shape (so that the selection handles show around it) and start typing. -- Rick (MVP - Excel) "dhstein" wrote in message ... I can add the arrow - but there is no option to add text "Billy Liddel" wrote: Activate the Drawing Toolbar, select Block Arrows from the Autoshapes options. Click on the arrow of choice and draw it on the sheet by holding down the mouse button and dragging diagonally down to the right. You can choose a fill colour at this stage. Click off the arrow then right-click on it and choose Add Text. When the text is added click off then clcik on the arrow. if a rectangle is selected then click the Centre button to centre the Arrow text. Is this helps please click Yes. Peter "dhstein" wrote: I want to create a large arrow big enough to put some text within the outline of the arrow and insert the text. I've seen examples of this so I know it can be done, but I'm not sure how. Thanks for any help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to insert a special character (arrow) in IF statement | Excel Worksheet Functions | |||
Editing conditional formatting formula, arrow keys insert range. | Excel Discussion (Misc queries) | |||
i need to insert data in a large spreadsheet | Excel Discussion (Misc queries) | |||
Insert an Arrow from Draw Toolbar | Excel Discussion (Misc queries) | |||
Insert large excel object into word | Excel Discussion (Misc queries) |