Drawing Lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne Hummer - 15 Sep 2005 17:31 GMT

Is there an easy way to draw lines around a range of cells where you can
specify to draw the line on the top, bottom, left or right side of the
range?

Thanks.

Reply to this Message

Mike - 15 Sep 2005 17:47 GMT

highlight the range of cells, right click on the higlighted area, click
Format, click borders. You should play around with the borders until you
understand each border button behavior. Set thickness of the line is on the
right. I normally do bold lines around the edge then in between cells I
usually go with a thinner line.

> Is there an easy way to draw lines around a range of cells where you can
> specify to draw the line on the top, bottom, left or right side of the
> range?
>
> Thanks.

Reply to this Message

David McRitchie - 15 Sep 2005 19:53 GMT

a good idea, but you can also do this from the borders dropdown
that you either have on the toolbar or can add to the toolbar.

It is the one in the lower right corner of the twelve choices in the
dropdown for thick box border, or the one to the left of it.
For anything more complicated than the choices on the dropdown
you would certainly have to use Mike's suggestion.
http://www.mvps.org/dmcritchie/excel/toolbars.htm

If the borders dropdown is not defaulted on the toolbar you can
get it from tools, customize, commands (tab), format (left), borders (right)
choose the one with the arrow to the right so you have the drop down.
You drag that to your toolbars.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> highlight the range of cells, right click on the higlighted area, click
> Format, click borders. You should play around with the borders until you
[quoted text clipped - 7 lines]
> >
> > Thanks.

Reply to this Message