Automatically Format cell

  • Thread starter Thread starter amber
  • Start date Start date
A

amber

Is there a way to set the formatting to automatically
adjust cell size based on the text I type in? I know
about using the Format-Autofit, but I'm looking for
something that works while I type.


Thanks, in advance,
Amber
 
Hi
you'll have to use VBA for this. Put the following code in your
worksheet module:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub
With Target
If .Value <> "" Then
.Columns.AutoFit
End If
End With
End Sub

this will check entries in column A and if anything is entered applie
the autofit on this column. Change the range to your needs
 
Amber

No.

When you are typing Excel has no way of knowing what you are doing.

Only after you hit the <ENTER> key or otherwise leave the cell will Excel
respond with the Autofit and other stuff.

I see Frank has provided a macro, but it still involves hitting the <ENTER>
key before the Event is fired.

Gord Dibben Excel MVP
 
Gord said:
Amber

No.

When you are typing Excel has no way of knowing what you are doing.

Only after you hit the <ENTER> key or otherwise leave the cell will
Excel respond with the Autofit and other stuff.

I see Frank has provided a macro, but it still involves hitting the
<ENTER> key before the Event is fired.
Click to expand...

Hi Gord
thanks for this addition, missed this part in the OP question :-)
Frank
 
Fran

The "while I type" part was kinda hidden at the bottom. Who reads that far
down?<g>

Gord
 
Back
Top