cell size problem

K

kmurren

I am using Excel as a database for a film festival. We include short synopses
that can be up to 500 words in a single cell. We don't want to view the whole
synopsis, but simply to be able to reference/read it when we need to.

The Problem:
Often when I copy text into the cell it automatically changes the cell
height to display all the text, while wrapping the text to maintain column
width. But then again, sometimes it doesn't. I can't get it to maintain both
column width and cell height consistently. And I can't figure out why it's a
problem sometimes and not a problem other times.

In order to get the cell back to its original display size, I right-click
and format the cell by de-selecting text wrapping (The text seems to wrap as
a default).

Why can't I get wrapping to stay off as a default?

When I select the whole document and turn off text wrapping I still have the
problem the next time I copy longer text into the excel document. The same is
true if I select the row and change the height back to the original height.
Like wrapping this doesn't seem to hold for the next opperation...

This is really frustrating I am constantly having to reformat the cells to
maintain the size. I just want the cell height and width to remain the same
all the time no matter what I drop into the cell. Is this possible?

Any help would be much appreciated. Thanks.
 
J

Jim Rech

When you copy text into Excel that has a carriage return and/or line feed it
seems to automatically turns on word wrap for that cell. I don't know of a
way to prevent this. You could run a macro on the selection after the paste
to simply fixing the text:

Sub StraightenOut()
Selection.WrapText = False
Selection.Replace Chr(13), " ", xlPart
Selection.Replace Chr(10), " ", xlPart
End Sub


--
Jim Rech
Excel MVP
|I am using Excel as a database for a film festival. We include short
synopses
| that can be up to 500 words in a single cell. We don't want to view the
whole
| synopsis, but simply to be able to reference/read it when we need to.
|
| The Problem:
| Often when I copy text into the cell it automatically changes the cell
| height to display all the text, while wrapping the text to maintain column
| width. But then again, sometimes it doesn't. I can't get it to maintain
both
| column width and cell height consistently. And I can't figure out why it's
a
| problem sometimes and not a problem other times.
|
| In order to get the cell back to its original display size, I right-click
| and format the cell by de-selecting text wrapping (The text seems to wrap
as
| a default).
|
| Why can't I get wrapping to stay off as a default?
|
| When I select the whole document and turn off text wrapping I still have
the
| problem the next time I copy longer text into the excel document. The same
is
| true if I select the row and change the height back to the original
height.
| Like wrapping this doesn't seem to hold for the next opperation...
|
| This is really frustrating I am constantly having to reformat the cells to
| maintain the size. I just want the cell height and width to remain the
same
| all the time no matter what I drop into the cell. Is this possible?
|
| Any help would be much appreciated. Thanks.
 
Top