Change row height and column width values tothat of Excel for Windows

[jadams]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

After using Excel for Windows for so many years, I am used to the row height and column width values (I'm not even sure what the unit of measure is for the row height and column values in Windows).

Excel for Mac defaults these values to inches. Although, this is somewhat helpful, I'm so used to unit of measure in Excel for Windows that I would like to make those settings my default for Excel for Mac.

I see that you can change the Ruler preferences to inches, centimeters, or millimeters...but this still does not change the behavior like that of Excel for Windows.

Any suggestions?

Thanks in advance.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

After using Excel for Windows for so many years, I am used to the row height
and column width values (I'm not even sure what the unit of measure is for
the row height and column values in Windows).

Excel for Mac defaults these values to inches. Although, this is somewhat
helpful, I'm so used to unit of measure in Excel for Windows that I would
like to make those settings my default for Excel for Mac.

I see that you can change the Ruler preferences to inches, centimeters, or
millimeters...but this still does not change the behavior like that of Excel
for Windows.

Any suggestions?

Not sure exactly what you'd like suggestions about... you're right that
XL08 reports widths and heights in inches/cm/mm, but the actual internal
settings themselves are the same.

Column widths are in units of average Standard Font digit width. The
Standard Font is set in Preferences/General. So a width of 10 will hold
exactly 10 digits (digits in any given font are nearly always all the
same width, even in proportional fonts). If you click on a column
separator, the first number will report the width in "digits". Drag
right or left to set the column width.

FWIW, you could have found a similar explanation in the "Change the unit
of measurement" topic of Excel Help:

Tip: You can still measure the column width in terms of number
of standard font character units by dragging the column separator...


Row Heights are in points. You can similarly see the "old style" units
by dragging the row separators.