In excel i want to merge cells a1 thru a5 and wrap the text in the newly
created cell. I highlight the cells go to format /cells/alignment and check
wrap text and merge cells. The cells are merged but when I type a long string
it does not wrap auotmatically increase the hieght of the row so i can see
everything i typed in.

You cannot format an empty cell. Enter the data first and then format it.

"leo" wrote:

In excel i want to merge cells a1 thru a5 and wrap the text in the newly
created cell. I highlight the cells go to format /cells/alignment and check
wrap text and merge cells. The cells are merged but when I type a long string
it does not wrap auotmatically increase the hieght of the row so i can see
everything i typed in.

Merged cells with wrap text but.............they won't Autofit.

You must drag them to fit or use event code in the worksheet to assist.

See this google search result.

http://snipurl.com/1dmgw

Note: cells must be pre-formatted to Wrap Text and Rows set to Autofit.


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 10:28:15 -0700, leo wrote:

In excel i want to merge cells a1 thru a5 and wrap the text in the newly
created cell. I highlight the cells go to format /cells/alignment and check
wrap text and merge cells. The cells are merged but when I type a long string
it does not wrap auotmatically increase the hieght of the row so i can see
everything i typed in.