+ Reply to Thread
Results 1 to 6 of 6

How to the decimal places in the row height and column width settings.

  1. #1
    Registered User
    Join Date
    06-19-2010
    Location
    NT, NY
    MS-Off Ver
    Excel 2019
    Posts
    9

    How to the decimal places in the row height and column width settings.

    Excel rounds off the row height and column width settings to two decimal places.
    Is there a way to increase this to three or four places?

    Jim

    BTY. I am running Office professional plus 2019 not 2007 as shown on my post.
    Last edited by jimbir; 12-30-2023 at 06:56 PM. Reason: Correction

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,427

    Re: How to the decimal places in the row height and column width settings.

    You can calculate the width and height yourself.

    The width and height can't be anything other than an integer number of pixels.
    Excel charges me 3/4 per pixel for the height and for the width Exel charges me 1/12 per pixel for the first 12 pixels and then 1/7 per pixel.
    Example: If the column on the screen is 50 pixels wide, Excel indicates a width of 12*1/12 + (50-12)*1/7 = 6 3/7 is 6.4286 (rounded to 4 decimal places) is 6.43 (rounded to 2 decimal places)

    However, I don't know if these numbers depend on local settings and/or font settings.

    In Excel, you can't set the height and width more accurately. Each height is rounded to a multiple of 3/4 and any width greater than 1 is rounded to a multiple of 1/7 (and then to 2 decimal places) and any width less than 1 is rounded to a multiple of 1/12 (and then to 2 decimal places).

    So I don't think it makes sense to round the height or width to 3 or 4 decimal places.
    Last edited by HansDouwe; 12-30-2023 at 10:22 PM.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: How to the decimal places in the row height and column width settings.

    Quote Originally Posted by jimbir View Post
    ... BTY. I am running Office professional plus 2019 not 2007 as shown on my post ...
    Please update your profile to show this, by clicking on User CP in the menu near the top of the screen.

    Pete

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: How to the decimal places in the row height and column width settings.

    I think you see no difference between 6.4286 and 6.43
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    06-19-2010
    Location
    NT, NY
    MS-Off Ver
    Excel 2019
    Posts
    9

    Re: How to the decimal places in the row height and column width settings.

    Thanks for the Reply. The reason for my question is explained below.
    I have set a column width to .375. When I right click on it and select column width in the drop-down menu, I see .37. I’d really like to see .375. That is why I would like to be able to set the decimal places to something more than 2.

    Now, when I switch from the Page layout view to normal, I see the number 3.6. What does that indicate? Pixels?

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: How to the decimal places in the row height and column width settings.

    I think it might be in points, which is an old printing measure for 1/12th of an inch.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-09-2022, 12:23 PM
  2. [SOLVED] Column Width settings
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-28-2019, 04:18 PM
  3. Replies: 2
    Last Post: 02-26-2016, 11:38 PM
  4. Column Width Decimal Places Rounding
    By georgeanaprop in forum Excel General
    Replies: 4
    Last Post: 07-19-2010, 09:51 AM
  5. Row height/column width
    By Connie Martin in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 12:55 PM
  6. Decimal Places - Settings for Auto Rounding Up/Down
    By Holmes, Maria in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2006, 01:55 PM
  7. height and width settings locked?
    By Lab Teacher in forum Excel General
    Replies: 2
    Last Post: 10-05-2005, 03:05 PM

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