1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

convert cell sizes to inches

Discussion in 'Business Applications' started by MPeg3, Jan 3, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. MPeg3

    MPeg3 Thread Starter

    Joined:
    Sep 13, 2004
    Messages:
    684
    I'm using Excel 2003. Is there a formula I could use to set my cells to a certain size in inches. i.e. if I wanted a cell to be 2"x3", how could I figure that out so each cell would be the size I want?
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,271
    Interesting. How exact do you want this? What I would do, rather than mess about with code, is draw a rectangle, set it's "Object positioning" property (Format > AutoShape) to "Don't move or size" and it's size to whatever, & then use it as a guide.

    You can have an AutoShape snap to cell borders by holding down ALT while dragging it around, if that helps. & I read that for row heights, 72pts =1 inch, if that helps too. :)
     
  3. MPeg3

    MPeg3 Thread Starter

    Joined:
    Sep 13, 2004
    Messages:
    684
    Thanks that worked.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/667592