Auto-wrap after copy/paste and Merging

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

Is there a way to turn back on the auto-wrap feature after
merging cells, or copy/pasting into them? We have the
auto-wrap feature turned on, auto height, and still no
word wrap when typing in new data.

TIA
BJ
 
BJ

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resizing merged / wrapped cells. 2
Can word wrap and merged cells auto row height properly in Excel 1
Auto adjusting merged cells with wrap text on 1
wrapping text in merged cells 2
Wrap around setting won't adjust row hieght 3
Cells ignore Wrap Text formatting! 2
Wrap text in merged cells VBA 2
Row Height - Auto-Fit 1

Back
Top