Can't Wrap text in the Merge Cells
 

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Can't Wrap text in the Merge Cells
 

Hi,

It should work ...
Try again by removing all formats and repeating your process ...

HTH
Carim

Can't Wrap text in the Merge Cells
 

U can... increase row height.
Format-Rows-Height

pls do rate

"Winnie" wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Can't Wrap text in the Merge Cells
 

This is change a rows height by manaully
but the system can't wrap test automatic?


"Carim" wrote:

Hi,

It should work ...
Try again by removing all formats and repeating your process ...

HTH
Carim

Can't Wrap text in the Merge Cells
 

but not Wrap text automatic?
just only change manaully

"Carim" wrote:

Hi,

It should work ...
Try again by removing all formats and repeating your process ...

HTH
Carim

Can't Wrap text in the Merge Cells
 

format-cell-Alighnment-active wrap text

"Winnie" wrote:

This is change a rows height by manaully
but the system can't wrap test automatic?


"Carim" wrote:

Hi,

It should work ...
Try again by removing all formats and repeating your process ...

HTH
Carim

Can't Wrap text in the Merge Cells
 

I was enable Wrap text and Merge Cell function, but the Wrap text function
not working.

If I only enable Wrap Text function, the function can working. but if enable
both function, the Wrap function not working

"Muhammed Rafeek M" wrote:

format-cell-Alighnment-active wrap text

"Winnie" wrote:

This is change a rows height by manaully
but the system can't wrap test automatic?


"Carim" wrote:

Hi,

It should work ...
Try again by removing all formats and repeating your process ...

HTH
Carim

Can't Wrap text in the Merge Cells
 

Winnie,

When you wrap text in a single cell the row height will be automatically
resized. But if you merge cells and wrap text. the resizing should be done
manually. I believe this is a drawback of Excel.

Regards,

Jaleel


"Muhammed Rafeek M" wrote:

format-cell-Alighnment-active wrap text

"Winnie" wrote:

This is change a rows height by manaully
but the system can't wrap test automatic?


"Carim" wrote:

Hi,

It should work ...
Try again by removing all formats and repeating your process ...

HTH
Carim

Can't Wrap text in the Merge Cells
 

Winnie

Wrap text works fine on merged cells.

Your problem is...............Rows with Merged cells will not Autofit.

You need VBA code to do that.

Here is code from Greg Wilson.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next
Application.ScreenUpdating = False
ma.MergeCells = False
c.ColumnWidth = MrgeWdth
c.EntireRow.AutoFit
NewRwHt = c.RowHeight
c.ColumnWidth = cWdth
ma.MergeCells = True
ma.RowHeight = NewRwHt
cWdth = 0: MrgeWdth = 0
Application.ScreenUpdating = True
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:18:01 -0700, Winnie
wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Gord Dibben MS Excel MVP

Can't Wrap text in the Merge Cells
 

I am having the same issue, please could you explain how to use the VBA code
below.

Thanks

Melanie

"Gord Dibben" wrote:

Winnie

Wrap text works fine on merged cells.

Your problem is...............Rows with Merged cells will not Autofit.

You need VBA code to do that.

Here is code from Greg Wilson.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next
Application.ScreenUpdating = False
ma.MergeCells = False
c.ColumnWidth = MrgeWdth
c.EntireRow.AutoFit
NewRwHt = c.RowHeight
c.ColumnWidth = cWdth
ma.MergeCells = True
ma.RowHeight = NewRwHt
cWdth = 0: MrgeWdth = 0
Application.ScreenUpdating = True
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:18:01 -0700, Winnie
wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Gord Dibben MS Excel MVP

Can't Wrap text in the Merge Cells
 

This is event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that module.

Notes from Greg.................

The WrapText property of the merged cells has to be set to True.

The merged cells must be merged horizontally (e.g. A2 + B2 + C2 etc.) as
opposed to vertically (e.g. A2 + A3 + A4...). If your cells are merged
vertically then the code won't work.


Gord


On Tue, 19 Sep 2006 08:14:02 -0700, Melanie
wrote:

I am having the same issue, please could you explain how to use the VBA code
below.

Thanks

Melanie

"Gord Dibben" wrote:

Winnie

Wrap text works fine on merged cells.

Your problem is...............Rows with Merged cells will not Autofit.

You need VBA code to do that.

Here is code from Greg Wilson.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next
Application.ScreenUpdating = False
ma.MergeCells = False
c.ColumnWidth = MrgeWdth
c.EntireRow.AutoFit
NewRwHt = c.RowHeight
c.ColumnWidth = cWdth
ma.MergeCells = True
ma.RowHeight = NewRwHt
cWdth = 0: MrgeWdth = 0
Application.ScreenUpdating = True
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:18:01 -0700, Winnie
wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Gord Dibben MS Excel MVP

Can't Wrap text in the Merge Cells
 

Hi,
i currently use excel 2004 for mac, and i have the same problem: merged cell
won't autofit.
I executed the instructions above but it still doesn't work.
So what to do next?

"Gord Dibben" wrote:

This is event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that module.

Notes from Greg.................

The WrapText property of the merged cells has to be set to True.

The merged cells must be merged horizontally (e.g. A2 + B2 + C2 etc.) as
opposed to vertically (e.g. A2 + A3 + A4...). If your cells are merged
vertically then the code won't work.


Gord


On Tue, 19 Sep 2006 08:14:02 -0700, Melanie
wrote:

I am having the same issue, please could you explain how to use the VBA code
below.

Thanks

Melanie

"Gord Dibben" wrote:

Winnie

Wrap text works fine on merged cells.

Your problem is...............Rows with Merged cells will not Autofit.

You need VBA code to do that.

Here is code from Greg Wilson.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next
Application.ScreenUpdating = False
ma.MergeCells = False
c.ColumnWidth = MrgeWdth
c.EntireRow.AutoFit
NewRwHt = c.RowHeight
c.ColumnWidth = cWdth
ma.MergeCells = True
ma.RowHeight = NewRwHt
cWdth = 0: MrgeWdth = 0
Application.ScreenUpdating = True
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:18:01 -0700, Winnie
wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Gord Dibben MS Excel MVP

Can't Wrap text in the Merge Cells
 

Find!

i had to change options of the code window's menu



"Calou" wrote:

Hi,
i currently use excel 2004 for mac, and i have the same problem: merged cell
won't autofit.
I executed the instructions above but it still doesn't work.
So what to do next?

"Gord Dibben" wrote:

This is event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that module.

Notes from Greg.................

The WrapText property of the merged cells has to be set to True.

The merged cells must be merged horizontally (e.g. A2 + B2 + C2 etc.) as
opposed to vertically (e.g. A2 + A3 + A4...). If your cells are merged
vertically then the code won't work.


Gord


On Tue, 19 Sep 2006 08:14:02 -0700, Melanie
wrote:

I am having the same issue, please could you explain how to use the VBA code
below.

Thanks

Melanie

"Gord Dibben" wrote:

Winnie

Wrap text works fine on merged cells.

Your problem is...............Rows with Merged cells will not Autofit.

You need VBA code to do that.

Here is code from Greg Wilson.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next
Application.ScreenUpdating = False
ma.MergeCells = False
c.ColumnWidth = MrgeWdth
c.EntireRow.AutoFit
NewRwHt = c.RowHeight
c.ColumnWidth = cWdth
ma.MergeCells = True
ma.RowHeight = NewRwHt
cWdth = 0: MrgeWdth = 0
Application.ScreenUpdating = True
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:18:01 -0700, Winnie
wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Gord Dibben MS Excel MVP

Can't Wrap text in the Merge Cells
 

I use an excel template where I have to use merged cells because the
data being transferred too the document is too large for a single cell.
This merged cell happens to be merged horizontally and vertically. I am
able to wrap text if the entry is small, but I run into problems when
there are multiple lines of text wrapping. It seems as if there is a
limit on the number of rows excel will wrap within a specific merged
cell, but this limit may vary. I have experienced this same problem on
unmerged cells. Can anyone help?

Gord Dibben wrote:
This is event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that module.

Notes from Greg.................

The WrapText property of the merged cells has to be set to True.

The merged cells must be merged horizontally (e.g. A2 + B2 + C2 etc.) as
opposed to vertically (e.g. A2 + A3 + A4...). If your cells are merged
vertically then the code won't work.


Gord


On Tue, 19 Sep 2006 08:14:02 -0700, Melanie
wrote:

I am having the same issue, please could you explain how to use the VBA code
below.

Thanks

Melanie

"Gord Dibben" wrote:

Winnie

Wrap text works fine on merged cells.

Your problem is...............Rows with Merged cells will not Autofit.

You need VBA code to do that.

Here is code from Greg Wilson.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next
Application.ScreenUpdating = False
ma.MergeCells = False
c.ColumnWidth = MrgeWdth
c.EntireRow.AutoFit
NewRwHt = c.RowHeight
c.ColumnWidth = cWdth
ma.MergeCells = True
ma.RowHeight = NewRwHt
cWdth = 0: MrgeWdth = 0
Application.ScreenUpdating = True
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:18:01 -0700, Winnie
wrote:

When I choose Merge cells and Wrap text function in the Text control.

the Wrap text function not working in the merger cells?

Please help

Gord Dibben MS Excel MVP