Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Archive: Business Applications Archive: Business Applications
Search Search
Search for:
Tech Support Guy > > > >

Solved: Excel Word Wrap inconsistencies


(!)

Erm's Avatar
Erm Erm is offline
Member with 298 posts.
THREAD STARTER
 
Join Date: Jul 2003
Location: UK
04-Dec-2006, 06:44 AM #1
Solved: Excel Word Wrap inconsistencies
Please help...this is driving me insane! I have an Excel spreadsheet and in one cell I have a large amount of text. This cell is a number of cells merged together and has Word Wrap on. It is also aligned horizontally as general and vertically as top.

The issue is that sometimes (only once) the Word Wrap seems to be working and the remainder of the time the last bit of text disappears! It is all there and appears correctly when editing the field. Any ideas?

Thanks
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
04-Dec-2006, 07:55 AM #2
Merged cells are a PITA, basically.

When you say "the last bit of text disappears", would that be the "bottom line"?

Can you upload your file (or at least a copy of the offending bit) for inspection?
Yorkshire Guy's Avatar
Yorkshire Guy Yorkshire Guy is offline
Member with 563 posts.
 
Join Date: Dec 2003
Location: Yorkshire, UK
04-Dec-2006, 07:58 AM #3
Hi Erm,

I see the same thing all the time!

Manually changing the row height (just drag the row number bottom line down) works to 'expose' the text, but often double clicking the same has no affect.

I hope someone else has a more definitive fix!

lol
Hew
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
04-Dec-2006, 08:10 AM #4
That's it, in a nutshell -- merged cells are resistant to AutoFit.

A macro fix does exist, if you'd like me to dig it out.
Erm's Avatar
Erm Erm is offline
Member with 298 posts.
THREAD STARTER
 
Join Date: Jul 2003
Location: UK
04-Dec-2006, 08:41 AM #5
The dragging does normally work...but not on this one....its very weird!...for the time being I have replace the offending information with a text box since is is like a disclaimer at the bottom of the spreadsheet. However, I do have other spreadsheets with the same issue, so if you could find me the macro fix, it would be greatly appreciated.

Debs
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
04-Dec-2006, 09:07 AM #6
Dragging will work, but Format > Row > AutoFit will not (in my XP).

The macro is by Jim Rech (an MVP, I believe). If you need help installing it, post back.

----------------------------------------------------------------------------------------------------

Sub AutoFitMergedCellRowHeight()
Dim CurrentRowHeight As Single, MergedCellRgWidth As Single
Dim CurrCell As Range
Dim ActiveCellWidth As Single, PossNewRowHeight As Single
If ActiveCell.MergeCells Then
With ActiveCell.MergeArea
If .Rows.Count = 1 And .WrapText = True Then
Application.ScreenUpdating = False
CurrentRowHeight = .RowHeight
ActiveCellWidth = ActiveCell.ColumnWidth
For Each CurrCell In Selection
MergedCellRgWidth = CurrCell.ColumnWidth + MergedCellRgWidth
Next
.MergeCells = False
.Cells(1).ColumnWidth = MergedCellRgWidth
.EntireRow.AutoFit
PossNewRowHeight = .RowHeight
.Cells(1).ColumnWidth = ActiveCellWidth
.MergeCells = True
.RowHeight = IIf(CurrentRowHeight > PossNewRowHeight, _
CurrentRowHeight, PossNewRowHeight)
End If
End With
End If
End Sub
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
04-Dec-2006, 12:46 PM #7
I agree with Andy, don't merge cells. If you're wanting to add large text, either enlarge the columns/rows or use a textbox that moves with the columns/rows over which you place it. If you're making a form, Word may be a better application.

Edit: And yes, Jim R. is an Excel MVP.
Erm's Avatar
Erm Erm is offline
Member with 298 posts.
THREAD STARTER
 
Join Date: Jul 2003
Location: UK
05-Dec-2006, 11:11 AM #8
Thanks for all your help guys....much appreciated!
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
05-Dec-2006, 12:34 PM #9
Debs, if this solves your problem, don't forget to mark your thread as Solved, you can do so by going to Thread Tools | Mark Solved | Perform Action.

Take care!
Erm's Avatar
Erm Erm is offline
Member with 298 posts.
THREAD STARTER
 
Join Date: Jul 2003
Location: UK
07-Dec-2006, 10:23 AM #10
I was looking where to do that when I made my last post but couldn't find the option...Thanks!
Billman64's Avatar
Billman64 Billman64 is offline
Junior Member with 1 posts.
 
Join Date: Aug 2008
Experience: Intermediate
26-Aug-2008, 02:56 PM #11
new solution - line break
Only the last line not showing? Sounds like Word Wrap has a limit to the amount of text in an Excel cell. I'm experiencing the same thing, but have a different solution.

While in editing mode for that cell, put the text cursor somewhere on the last line of the text and hit Alt + Enter to insert a line break.

The thing is now that part of the cell won't auto-adjust if you change the width.

Last edited by Billman64; 26-Aug-2008 at 03:01 PM..
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑