#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default draw corners

I have seen people use excel for effectively drawing and highlighting text
and data by coloring cells in a way that results in effect the cells looking
like arrows...I have also seen where this is done in "corners" of these
shadings looking "rounded". Now this isn't done - i don't think - using
lines/borders etc...but I can't figure out how it is done...I don't even
really know what it is called so I can't search for it. I'd attached a
picture to this post - I have one - if I could.

Don't know if this is enough to help me find what I'm looking for in an
example/template...let me know of if I can provide additional explaniation to
help me get there...thanks in advance!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 181
Default draw corners

If I understand correctly you are talking about inserting shapes (arrows in
your case)

In 2007

On the ribbon select Insert tab - Select illustrations - Shapes - Select
required shape - now when you go to your w/sheet the cursor has turned to +
Click and drag to draw the shape.

In 2003 you need to open the drawing toolbar
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Tim Myers" wrote:

I have seen people use excel for effectively drawing and highlighting text
and data by coloring cells in a way that results in effect the cells looking
like arrows...I have also seen where this is done in "corners" of these
shadings looking "rounded". Now this isn't done - i don't think - using
lines/borders etc...but I can't figure out how it is done...I don't even
really know what it is called so I can't search for it. I'd attached a
picture to this post - I have one - if I could.

Don't know if this is enough to help me find what I'm looking for in an
example/template...let me know of if I can provide additional explaniation to
help me get there...thanks in advance!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default draw corners

I'm not sure what the effect is you're looking for, but the drawing of arrows
could have been done with the drawing toolbar- autoshapes - block arrows;
the arrows can then be shaded with text added.

"Tim Myers" wrote:

I have seen people use excel for effectively drawing and highlighting text
and data by coloring cells in a way that results in effect the cells looking
like arrows...I have also seen where this is done in "corners" of these
shadings looking "rounded". Now this isn't done - i don't think - using
lines/borders etc...but I can't figure out how it is done...I don't even
really know what it is called so I can't search for it. I'd attached a
picture to this post - I have one - if I could.

Don't know if this is enough to help me find what I'm looking for in an
example/template...let me know of if I can provide additional explaniation to
help me get there...thanks in advance!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default draw corners

thanks folks...but it's not quite right...but follow the attached link to:

http://www.4shared.com/file/23838698...0/example.html

here's a small snippit of what I want to do...

thanks!


"marysully" wrote:

I'm not sure what the effect is you're looking for, but the drawing of arrows
could have been done with the drawing toolbar- autoshapes - block arrows;
the arrows can then be shaded with text added.

"Tim Myers" wrote:

I have seen people use excel for effectively drawing and highlighting text
and data by coloring cells in a way that results in effect the cells looking
like arrows...I have also seen where this is done in "corners" of these
shadings looking "rounded". Now this isn't done - i don't think - using
lines/borders etc...but I can't figure out how it is done...I don't even
really know what it is called so I can't search for it. I'd attached a
picture to this post - I have one - if I could.

Don't know if this is enough to help me find what I'm looking for in an
example/template...let me know of if I can provide additional explaniation to
help me get there...thanks in advance!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default draw corners

The picture was very small; the arrows, etc. looked like some type of
symbols. If you go to Insert-Symbols you can insert arrows, etc. and then
format the cells with borders and shading. Just an idea, not sure if that's
what you're looking for.

"Tim Myers" wrote:

thanks folks...but it's not quite right...but follow the attached link to:

http://www.4shared.com/file/23838698...0/example.html

here's a small snippit of what I want to do...

thanks!


"marysully" wrote:

I'm not sure what the effect is you're looking for, but the drawing of arrows
could have been done with the drawing toolbar- autoshapes - block arrows;
the arrows can then be shaded with text added.

"Tim Myers" wrote:

I have seen people use excel for effectively drawing and highlighting text
and data by coloring cells in a way that results in effect the cells looking
like arrows...I have also seen where this is done in "corners" of these
shadings looking "rounded". Now this isn't done - i don't think - using
lines/borders etc...but I can't figure out how it is done...I don't even
really know what it is called so I can't search for it. I'd attached a
picture to this post - I have one - if I could.

Don't know if this is enough to help me find what I'm looking for in an
example/template...let me know of if I can provide additional explaniation to
help me get there...thanks in advance!



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default draw corners

Thanks...no, It's more of a hand drawn thing in that "filling in" colors in
cells rows and columns gives you the appearance of a "line" that can bend
right angles...but I've see output there the "caps" if you will on the
corners are rounded...I think they must be hand drawn somehow...I just can't
figure out how the "color" is filled in only in the drawn area....hmmm. If I
come up with a better was to present the problem I'm trying to solve...I'll
repost. Thanks all.

T

"marysully" wrote:

The picture was very small; the arrows, etc. looked like some type of
symbols. If you go to Insert-Symbols you can insert arrows, etc. and then
format the cells with borders and shading. Just an idea, not sure if that's
what you're looking for.

"Tim Myers" wrote:

thanks folks...but it's not quite right...but follow the attached link to:

http://www.4shared.com/file/23838698...0/example.html

here's a small snippit of what I want to do...

thanks!


"marysully" wrote:

I'm not sure what the effect is you're looking for, but the drawing of arrows
could have been done with the drawing toolbar- autoshapes - block arrows;
the arrows can then be shaded with text added.

"Tim Myers" wrote:

I have seen people use excel for effectively drawing and highlighting text
and data by coloring cells in a way that results in effect the cells looking
like arrows...I have also seen where this is done in "corners" of these
shadings looking "rounded". Now this isn't done - i don't think - using
lines/borders etc...but I can't figure out how it is done...I don't even
really know what it is called so I can't search for it. I'd attached a
picture to this post - I have one - if I could.

Don't know if this is enough to help me find what I'm looking for in an
example/template...let me know of if I can provide additional explaniation to
help me get there...thanks in advance!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rectangle shape round top corners only goss[_2_] Excel Discussion (Misc queries) 1 June 29th 09 03:10 AM
Rounded corners on Tables Gaijintendo Excel Discussion (Misc queries) 1 July 8th 08 02:58 PM
Rounded Corners in Excel 2007 Not Working?!?! Kulprit Charts and Charting in Excel 7 April 14th 08 08:18 AM
How to have Excel worksheet open and see all the corners? Crisca Excel Discussion (Misc queries) 1 September 27th 07 03:35 PM
enter 2 values in opposite corners of a cell itsthebike Excel Discussion (Misc queries) 1 September 23rd 05 07:36 PM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"