how to Autofit row heights & column withs in excel tables

[asokaw]

I have an Excel table in which I need to auto fit the row height & wrap text automatically in new rows I enter

The column width can be fixed. an I do it with a macro or I there an easy way out

 

[oldbrewer]

do one cell ie wrap text, then use format painter on all other cells

 

[asokaw]

Thanks , but what I need is to automatically adjust the row height of the cell when entering data keeping the column width fixed

 

[oldbrewer]

format row, height, auto then format column, fixed (set your desired column width) set to wrap text
then use format painter

 

[asokaw]

Yes, but then I need to do it without using the Format Painter meaning when I type in a cell dynamically it should expand the row height

 

[oldbrewer]

once you have formatted all required cells with format painter, they will dynamically grow to accept extra text when you put it in

 

[asokaw]

once you have formatted all required cells with format painter, they will dynamically grow to accept extra text when you put it in

Thank you very much - it worked

 

[oldbrewer]

You are very welcome - helping people on here keeps my brain active - I hope - I am 68 ......

 

[asokaw]

Hi

If everybody in this world think like you, this world will be a very nice place to live

keep it up, I am also 53 yrs old

wish you good health