Col width and row height

[Francis Hookham]

2004 seems to want to define cell height/widths in inches, cms or mms

Dragging a row/col shows me the dimensions I am used to as well as the
inches, cms or mms but, if I want to define the cell height/widths I have to
use inches, cms or mms

Or have I missed a setting which would get me back to Œthe good old days¹?

Francis Hookham

 

[CyberTaz]

It does, in fact, appear that MS has caught up with the times and gotten
away from the 'characters' measurement now that scalable fonts have been the
predominant force for eons. A welcome change for many, but understandably
perplexing for others.

I know of no way to revert to the previous system, but if you set the
widths/heights using the dragging technique, that value as well as that of
the current measurement system value will appear in a yellow tip box.

HTH |:>)

 

[JE McGimpsey]

2004 seems to want to define cell height/widths in inches, cms or mms

Dragging a row/col shows me the dimensions I am used to as well as the
inches, cms or mms but, if I want to define the cell height/widths I have to
use inches, cms or mms

Or have I missed a setting which would get me back to Œthe good old days¹?

You can still set the widths in numeric character units via VBA. In the
immediate window (Opt-F11/CMD-G) you can type:

Columns("A").ColumnWidth = 10

or you could use a macro:

Public Sub SetColumnWidth()
Const sPROMPT As String = _
"Width in characters for active column" & _
vbNewLine & "(Fractional values may be approximate):"
Dim vResponse As Variant
vResponse = Application.InputBox( _
Prompt:=sPROMPT, _
Title:="Column Width", _
Default:=10, _
Type:=1)
'False = user cancelled
If Not vResponse = False Then _
ActiveCell.EntireColumn.ColumnWidth = vResponse
End Sub