![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#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 |
|
|
|
#2 |
|
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.
|
|
|
|
|
|
#3 |
|
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 |
|
|
|
|
|
#4 |
|
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 |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|