Automatic change rowsize when writing

**Oeysbrei** · 07-12-2012, 05:39 AM

Hi,

Is there a way to make Excel change the size of a row and break the text so that I can see all text that has been writen in a single cell?

Thanks in advance

Regards
Øystein

**Oeysbrei** · 07-12-2012, 07:48 AM

Hello,

Bump

**Oeysbrei** · 07-13-2012, 02:25 AM

Hi,

I have an Excel document that changes the row size automatic so that I can read all text writen in a single cell.
But I hav another Excekfile where this is not the case.

My question: Is there something I can do with the settings that makes the row change size automatic when I write in a single cell?

Regards

Øystein

**vlady** · 07-13-2012, 02:50 AM

maybe ???? with code...
macro or in worksheet change event..

Please Login or Register  to view this content.

**Oeysbrei** · 07-13-2012, 03:40 AM

Thanks for the reply

I placed the code you gave me in Thisworkbook, but it dident work.
Since the cells change size automatic in earlyer versions of Excel, I would think it should be possible to do some changes in the settings, wouldent you?

By the way, am using Excel 2010 student version

Regards

Øystein