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?

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?

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

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