+ Reply to Thread
Results 1 to 4 of 4

Row height/column width curiosity question

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    41

    Row height/column width curiosity question

    So, I have a question out of curiosity, if anyone knows. I'm sure that anyone who has used Excel has probably noticed that a cell width of 10 is much greater than a row height of 10. Anyone have any idea why this is? I have tried to make cells as close to square as I can at times, but it is usually a bit of a guessing game.

    Thanks,


    Andrew

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    198

    Re: Row height/column width curiosity question

    After doing some research on this, one source suggested to get the row width and height for
    a perfect square, use the drawing tool to make a square in the size you want, then resize
    a cell height and width to fit around the square.
    Hold down the shift key when selecting the rectangle icon to draw a square.

    After you make your square, use your mouse in the column and row border areas when resizing row height and width and
    you should see the pixel and point values for the height or width. Use these point values to make your cells perfectly square.

    It was stated that the cell width represents number of characters, and the row height represents number of points.

    I found that when I reduced my screen resolution to the lowest setting available,
    the square gridlines appeared stretched out as horizontal rectangles.

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Row height/column width curiosity question

    Here are two useful links:

    Row height Column Width Ratio

    Excel Tip - Square Cells in Excel
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  4. #4
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Mexico
    Posts
    200

    Re: Row height/column width curiosity question

    Try:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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