#1   Report Post  
Posted to microsoft.public.excel.misc
fak119
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
fak119
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default 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
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do i print gridlines on my excel documents ymelord Excel Discussion (Misc queries) 3 March 19th 06 11:09 PM
Excel gridlines disappear when color is added nelson1344 Excel Discussion (Misc queries) 2 March 15th 05 12:37 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
excel gridlines print on top of text LaurieO Excel Discussion (Misc queries) 1 January 7th 05 01:05 AM


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

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

About Us

"It's about Microsoft Excel"