Wrapping text in merged cell

Feb 22nd, 2002, 08:03 AM

Excel 97 will not perform wrapping of text in merged cells. The automatic wrapping was okay in the single cell and increased the row height appropriately but when two or more cells are merged, no wrapping occurs and the row height doesn't change. I've tried reformatting to no avail.
pkra@hotmail.com

Russell Hauf · Feb 22nd, 2002, 09:50 AM

It works for me. I merged the cells, then went to Format-Cells (Ctrl+1), and clicked the Wrap Text check box in the Alignment tab. Text was then wrapped.

George J · Feb 22nd, 2002, 10:09 AM

Also ensure that you are changing the fields at the top to suit your preferences.

Horizontal to right and Vertical to Top.

Jack in the UK · Feb 22nd, 2002, 11:48 AM

Hi Guys --

BTW I seem to recall E97 wont if top aligned.. just a point..

Rdgs
==========
Jack

Feb 22nd, 2002, 10:09 AM	#3
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	Also ensure that you are changing the fields at the top to suit your preferences. Horizontal to right and Vertical to Top. __________________ George J

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 08:03 AM	#1
Guest Posts: n/a	Excel 97 will not perform wrapping of text in merged cells. The automatic wrapping was okay in the single cell and increased the row height appropriately but when two or more cells are merged, no wrapping occurs and the row height doesn't change. I've tried reformatting to no avail. pkra@hotmail.com

Feb 22nd, 2002, 09:50 AM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	It works for me. I merged the cells, then went to Format-Cells (Ctrl+1), and clicked the Wrap Text check box in the Alignment tab. Text was then wrapped.

Feb 22nd, 2002, 11:48 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Guys -- BTW I seem to recall E97 wont if top aligned.. just a point.. Rdgs ========== Jack