Wrapping Text

[Jackie]

I am using the wrap text function, but on some cells it
doesn't work. When it works ok, you can see all of the
text. Then on the cells it is not working on, you can
only see part of the text. It isn't resizing the cell.
Any suggestions on how to correct?

 

[David McRitchie]

Hi Jackie,

Wrapping text is working. You are not seeing the top of the
cell (or bottom on cell depends on your vertical alignment).

You can select all cell (Ctrl+A) then double-click on the
any boundary between the column numbers. which is the
same as Format, rows, resize ...

I think Jim Rech has posted replies on this either as the cause of the
problem or a solution. This is what I found, I thought I'd seen a little
better solution or work around.
http://google.com/groups?selm=#e4tEaJsAHA.832@tkmsftngp05

When you manually set a row height Excel treats that as an override to its
automatic row height and respects it. What you could do is give an out
of the way cell like in column IV a font size of say 16 so the default
height of the row will be about what you want and yet it will enlarge as
needed. -- Jim Rech

In other words once you resize you are stuck with the fact that you will have
to keep doing it. I wonder if there was a macro solution shown once to
remove some absolute row heights.

You can solve your problem by resizing all
rows after a manual change to any cell. If the problem content is due to
a formula it would get corrected on the next manual cell entry.

Install the following by right-click of the worksheet tab, then view code,
and place the code inside. You now have a macro. If you did not have
macros before you will now. You should make sure that your security level
is set to medium. Tools, Macro, Security, [x] Medium

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False 'should be part of Change macro
Cells.EntireRow.AutoFit
Application.EnableEvents = True 'should be part of Change macro
End Sub

More on event macros in
http://www.mvps.org/dmcritchie/excel/event.htm

Warning when you turn off EnableEvents and the macro fails after turning
them off you will have to run a regular macro to them back on.

 

[Gord Dibben]

Jackie

Are you working with "merged cells"?

If not, David's code will work fine so ignore the rest of this post unless you
want info only.

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