Row height - automatic adjustment

[Benelly]

Hi all,

Is there a way to have the row height adjust automatically to display all
the lines of text that may be in a particular cell ?

I have "WRAP TEXT" selected from the Alignment menu when you format the
contents of a cell but this does not automatically adjust the row height to
display all the lines of wrapped text.

I have been adjusting the row height manually and this is a pain in the
b...... when you have to do this each time your cell contains more than one
line of text.

Thanks in advance for any info that you can share with me.

Regards ..... Ben

 

[Ragdyer]

Doesn't work on "Merged Cells".
Are your cells merged?

BTW, once you *manually* adjust the row height, automatic adjustment is
suspended, even if the cells are *not* merged.

You can reset it by,
<Format> <Row> <AutoFit>

 

[Benelly]

Hi RD,

Thanks for the feedback.

What I would really like know is whether there is a setting in Excel 2003,
that would automatically perform the <Format> <Row> <AutoFit> sequence of
commands automatically as you enter the text into the cell without you
having to select the individual cell or row manually.

Regards ..... Ben

 

[Gord Dibben]

Ben

Not really.

You could format the entire worksheet or a range of rows/cells.

Hit CRTL + A to select all cells.

Format>Cells>Alignment>Wrap Text>OK

Format>Row>Autofit.

You could set up a SHEET.xlt template so all new worksheets are set this way.

You could also use worksheet event code to isolate the action to a certain
range of rows/cells.

Gord Dibben Excel MVP

 

[Benelly]

Hi Gord,

Thanks for your suggestions.

I think the "worksheet event code" sounds like it may be the best solution.
How would i go about setting up this event code. Excuse my lack of knowledge
in this area but is an event code the same as a "macro", which i believe
would still have to be run after the text has been input into the cell, or
something that would run automatically as soon as the text has been entered
into the cell.

I have done a quick search, not an extensive search, in the Excel "Help"
section and not found too much info on event codes.

Please could you point me in the right direction to enable me to try this
solution.

Regards ...... Ben

 

[Gord Dibben]

Ben

The code is invoked on leaving the cell after making an entry.

You do not run it from a button.

See David McRitchie's site for info on event code.

http://www.mvps.org/dmcritchie/excel/event.htm

Note the "Autofit" code part way down under "adjust row height automatically"

See also Chip Pearson's site for info on event code.

http://www.cpearson.com/excel/events.htm

Gord

 

[Benelly]

Hi Gord,

Thanks for the links.

Regards .... Ben

Ben

The code is invoked on leaving the cell after making an entry.

You do not run it from a button.

See David McRitchie's site for info on event code.

http://www.mvps.org/dmcritchie/excel/event.htm

Note the "Autofit" code part way down under "adjust row height
automatically"

See also Chip Pearson's site for info on event code.

http://www.cpearson.com/excel/events.htm

Gord