+ Reply to Thread
Results 1 to 4 of 4

Excel Gridlines

  1. #1
    fak119
    Guest

    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. #2
    Kevin B
    Guest

    RE: 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. #3
    fak119
    Guest

    RE: 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. #4
    Kevin B
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1