+ Reply to Thread
Results 1 to 3 of 3

Column/row measurements.

  1. #1
    1 of 1
    Guest

    Column/row measurements.

    Instead of the number system used for the height/width of columns & rows,
    can it be changed to measure in millimetres or centimetres?
    Even inches would be preferable to the default numbering system.



  2. #2
    Manuel Maza
    Guest

    Re: Column/row measurements.

    Hola,

    No es posible por una cuestion de diseņo de Excel.


    "1 of 1" <the.cube@deep.space.inv> wrote in message
    news:eKtBUDXiGHA.3588@TK2MSFTNGP02.phx.gbl...
    > Instead of the number system used for the height/width of columns & rows,
    > can it be changed to measure in millimetres or centimetres?
    > Even inches would be preferable to the default numbering system.
    >




  3. #3
    Gord Dibben
    Guest

    Re: Column/row measurements.

    Row heights are measured in points or pixels. There are 72 points to an inch
    and "maybe" 96 pixels to the inch.

    The number that appears in the Standard column width box is the average number
    of digits 0-9 of the standard font that fit in a cell.

    For an interesting and enlightening discussion on this subject see

    http://snipurl.com/dzz8

    If you want to use VBA to set height and width in mm.

    Ole Erlandson has code for setting row and column dimensions.

    http://www.erlandsendata.no/english/...vbawssetrowcol


    Gord Dibben Excel MVP

    On Tue, 6 Jun 2006 23:25:09 +0930, "1 of 1" <the.cube@deep.space.inv> wrote:

    >Instead of the number system used for the height/width of columns & rows,
    >can it be changed to measure in millimetres or centimetres?
    >Even inches would be preferable to the default numbering system.
    >


    Gord Dibben MS Excel MVP

+ 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