Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Gridlines
I know excel is not a drawing tool.
Nevertheless, I have to draw sometimes simple geometric figures (squares and rectangles) with measurments. This is easiest done when the gridlines are square. The closest I got was: Row hight 4.0, Column width o.42 which looks pretty square but enlarged it is not... Any idea which hights and widths produce a real square? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Gridlines
Why don't you use the rectangle tool on the Drawing tool bar. When you draw
a rectangle and hold down the shift key as you do it, you get a perfect square. You can then at text to the rectangle. Holding down shift while drawing an oval produces a perfect circle. -- Kevin Backmann "fak119" wrote: I know excel is not a drawing tool. Nevertheless, I have to draw sometimes simple geometric figures (squares and rectangles) with measurments. This is easiest done when the gridlines are square. The closest I got was: Row hight 4.0, Column width o.42 which looks pretty square but enlarged it is not... Any idea which hights and widths produce a real square? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Gridlines
Thanks, this works fine with single squares and rectangles, but not with a
little more complex "drawings" such as e.g. a floor plan, where the cell width or row hight might correspond to say, 1o cm or inches. "Kevin B" wrote: Why don't you use the rectangle tool on the Drawing tool bar. When you draw a rectangle and hold down the shift key as you do it, you get a perfect square. You can then at text to the rectangle. Holding down shift while drawing an oval produces a perfect circle. -- Kevin Backmann |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Gridlines
Sounds like you really need Visio, or some other type of charting
application. Visio has templates for floor plans. -- Kevin Backmann "fak119" wrote: Thanks, this works fine with single squares and rectangles, but not with a little more complex "drawings" such as e.g. a floor plan, where the cell width or row hight might correspond to say, 1o cm or inches. "Kevin B" wrote: Why don't you use the rectangle tool on the Drawing tool bar. When you draw a rectangle and hold down the shift key as you do it, you get a perfect square. You can then at text to the rectangle. Holding down shift while drawing an oval produces a perfect circle. -- Kevin Backmann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i print gridlines on my excel documents | Excel Discussion (Misc queries) | |||
Excel gridlines disappear when color is added | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
excel gridlines print on top of text | Excel Discussion (Misc queries) |