| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't Wrap text in the Merge Cells
Hi,
It should work ... Try again by removing all formats and repeating your process ... HTH Carim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrap text and row autofit not working in Excel | Excel Discussion (Misc queries) | |||
| Can't see text in cells | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Cells containing lots of text will not wrap? | Excel Discussion (Misc queries) | |||
| text wrap w/ merged cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
