Free Microsoft Excel 2013 Quick Reference

turn off Wrap Text

I just installed the SP2 for Office 2003 and now "wrapped" text does not
appear in my cells. They are not merged cells. Prior to updating, the wrapped
text automatically fit my text. Since updating, even if I manually resize the
row the text does not appear until I double-click the cell. Once I leave the
cell, the text disappears again?

When I turn off "wrap text", the text reappears.

Has anyone else experienced this? Is it a bug? Is there a workaround?

Thanks
Mark.


Post your answer or comment

comments powered by Disqus
I'm tired of always having to select all rows/columns, every time I start a
new workbook, and having to always TURN OFF text wrapping.

I tried to save that setting to the default sheet template, but I guess I
didn't do it right. Can someone tell me how to make NO WRAPPING the default?

I am trying to turn off the text to speech facility in Excel. Please help.

Suddenly wrapped text is not displaying in Excel. I can select the cell and
see the text in the function bar that it is in the cell and if I turn off
wrapping it displays. None of this text is very long. Thoughts?

How do I prevent Excel from automatically converting text that looks
like a date into a date. For example, if I type in 5-23 or 5/23, I
need to prevent Excel from converting it into May 23, 2006. In the
data I have, such text is not a date. Putting a single quote in front
of the apparent date to make it text is not a feasible option.

Similarly, does anyone know how turn off all the automatic formatting
in Word?

I am trying to import information that I want in one cell but because
of multiple colons and semicolons it is automatically put in different
cells. Is there any way to turn this off and/or turn off the text
import wizard?

How do I enter two lines of text in a single row - w/o merging cells?
Ok if the text spreads across adjacent columns.
Currently, if I turn off wrap text, both lines stay on one line with a pipe
symbol. If I turn on wrap text, the text tries to wrap in the single cell.
I can't expand the cell to accomodate all the text.

I have a cell that is auto populated from another worksheet. It is a cell
that contains what can be quite a long paragraph of text which can contain
multiple lines that have been input using (ALT - return).

The cell has been set as a merged cell of 10 rows (to allow for space if the
source data is across multiple lines).
I want this cell to be able to cope with whatever size of data the source
data contains). At the moment I have just left 10 lines available, but if
the source data cell contains information that is over 10 lines then this
will be cut off from the destination cell.

I want a way of handling this so in the cases where there is more then 10
lines, the destination cell pushes down all the rows below it to accommodate
for the extra space requirements.

In an ideal world, I could just use both shrink to fit and Wrap text,
because then if it is over 10 lines, the fonts just reduce in size to allow
for more, but if I turn this on, I have to turn off wrap text, which is
necessary because the contents is in a mutli line cell.

I do hope this makes sense and I look forward to any suggestions how one can
deal with this.

Kind regards

Dave

I have a worksheet filled with text data (sometimes multiple paragraphs). I need the rows to AutoFit based on the amount of text. Wrap text is turned on. However, not all the text is visible. After I use AutoFit I still have to go the the row and expand as necessary to avoid cutting off any text.

I have read the previous posts but none of them seem to help. Also, I know Excel is not a word processor but it is the only option in this case as the program the data comes from only lets you export to excel.

Anyone have any ideas? Has anyone had this problem before?

Is there any way to keep the hard returns in excel by using "Alt + Enter" AND at the same time, keep "wrap text" turned off?

For instance, click on a cell in excel and ensure wrap text is OFF. Type in a line for instance, "I was here today on this" and then hit the "alt + enter" combo then finish typing in the same cell, "sunny day."

When I do this, "wrap text" automatically turns on. And excel automatically adjusts ALL of the text so that the cell is not bigger than and fits the text.

I don't want it to do that. I actually want the text, "I was her today on this" to actually NOT wrap and just overlap into the next cell.

However, when I turn wrap text off, instead of keeping the hard "alt + enter," it puts in a little square and just turns into one single line.

Help is appreciated.

I've had an occasional problem with Excel 2000, but now I'm also
having it with Excel 2003.

Occasionally when I copy text from a web page, the text won't wrap. In
fact, when I've had the column set to wrap, after copying my text, the
wrapping has been turned off. But now, even when I turn it back on,
the test *may*, or may *not*, actually wrap.

I've copied my webpage text into notepad first, then copied it from
notepad to Excel. Still doesn't wrap.

I've copied another cell that *IS* wrapping, pasted it to the cell
that is NOT wrapping, and it behaves correctly by wrapping. As soon
as I paste in my text, the wrapping goes away, even though wrapping
has been, and is still..."checked".

Does *anyone* have *any* idea what's going on? Other than some damned
"Poltergeist" I mean.

Thanks in advance,

Tom

I have a column that I want to be 23 pixels wide with "wrap text" off (even
though the cells will contain project status comments - a large amount of
text).

In previous versions of Excel this was not a problem. I could format the
cell appropriately, enter my text (including several alt-enter line breaks)
and the cell would retain the desired format.

In Excel 2003 SP2 the behavior changed. Now, when I enter text that contains
alt-enter line breaks, "wrap text" gets automatically turned on and the row
height gets automatically adjusted - leaving me with a very tall cell (more
than can be displayed on one screen) with 1 or 2 character displayed per
line. Every time I update the comments in the cell I have to reset "wrap
text" to off and resize the row height.

How can I disable this new behavior? It makes it nearly impossible for me to
continue using a spreadsheet I have used for a very long time.

Recently, my computer started not displaying text in a cell when the cell is
formatted to wrap text. Even if I resize the cell column width or row height
to be wider than the contents of the cell, in the cell appears blank. Yet, I
can see the cell
contents in the Formula Bar and edit it. If I turn off the wrap text, the
cell contents reappears and if I turn it back on, it disappears again. If I
view the file from a different computer, the contents of the wrapped cell is
visible. HELP PLEASE!

I have large sentences placed in various cells in a large table.

When i first put the text in, it shows the whole sentence spilling out of the cell.

If i then 'wrap text', the row height automatically increases to fit the whole sentence in.

I then manually adjust the row height back to what it was, and you can then only see the very beginning of the sentence. This is what i want it to look like.

The problem is if i then ever sort the cells so the sentence ends up somewhere else, which i often do, it auto resizes again.

So, how do I turn this auto resize thing off? I have looked everywhere i can think of.
(using excel 2004 for mac, which is very similar to 2003 for pc)

Thanks

I've had an occasional problem with Excel 2000, but now I'm also
having it with Excel 2003.

Occasionally when I copy text from a web page, the text won't wrap. In
fact, when I've had the column set to wrap, after copying my text, the
wrapping has been turned off. But now, even when I turn it back on,
the test *may*, or may *not*, actually wrap.

I've copied my webpage text into notepad first, then copied it from
notepad to Excel. Still doesn't wrap.

I've copied another cell that *IS* wrapping, pasted it to the cell
that is NOT wrapping, and it behaves correctly by wrapping. As soon
as I paste in my text, the wrapping goes away, even though wrapping
has been, and is still..."checked".

Does *anyone* have *any* idea what's going on? Other than some damned
"Poltergeist" I mean.

Thanks in advance,

Tom

I'm using Excel to display what sometimes turns into long descriptions. When these description turn very long (the last time I had this problem it occurred after 1,043 characters) Excel begins cutting off characters. The exact point at which characters are cut off by Excel changes depending on the width of the column the characters are in, though the number of characters displayed does not change to any great degree. The text is of coarse word wrapped. The work around we use is to especially put the returns in for Excel. Thus if it cuts off at 1,043 characters I’ll go back to the first space and use Alt+Enter to put in a new line. This will buy you a few hundered more characters and then you need to put in more line breaks until the entire text displays.

This, as you might imagine is very tedious, and worse if I miss that a cells that is cutting off text it can end up on a power point presentation. Thus my question is this, does anyone know of a way to make Excel stop cutting off the text without manually putting the returns in?

Note: I’m using Excel 11.56… if that helps

I have a column that I want to be 23 pixels wide with "wrap text" off (even
though the cells will contain project status comments - a large amount of
text).

In previous versions of Excel this was not a problem. I could format the
cell appropriately, enter my text (including several alt-enter line breaks)
and the cell would retain the desired format.

In Excel 2003 SP2 the behavior changed. Now, when I enter text that contains
alt-enter line breaks, "wrap text" gets automatically turned on and the row
height gets automatically adjusted - leaving me with a very tall cell (more
than can be displayed on one screen) with 1 or 2 character displayed per
line. Every time I update the comments in the cell I have to reset "wrap
text" to off and resize the row height.

How can I disable this new behavior? It makes it nearly impossible for me to
continue using a spreadsheet I have used for a very long time.

Hi!

When I create bar chart with relatively long lables for categories on Y
(left) axis the program by default puts the label in one line. This means
that sometimes half of my screen is occupied by labels (i.e. "exchange of
cell phone ringtones") and the other half are the actual bars. This gets
pretty annoying when I have only few categories and the labels could easily
be written in 3 or even four lines.

Do you have any ideas hor to force the program to write labels in "wrap
text" mode?

Kind regards,
Sunshine

P.S. Another thing that's bothering me is the default "auto scale" option
for text in charts. Is there any way to turn it off?

I'm dealing with some data where I copy/paste stuff from a website onto an excel spreadsheet, and I'm doing it a ton (thousands of times by the end of this).

The problem is the cells wrap the text without me telling them to. Then I have to go in and disable wrap text for that individual cell.

Copy new piece of data, enter in new cell, excel auto wraps the text again. I have to unwrap text for that cell.

All the cells are have wrap text off, but when I copy/paste the data it activates wrap text. Is there any way to just turn wrap text off indefinately?

Thanks guys,

Zach

I've been trying to find information on turning off one of excel's default features. I have a very large chunck of VBA code that extracts data from an acess database and outputs it onto excel, however some data is being "Confused" as a dates.
What I need to do is make sure that a value such as "1SEP" isn't being confused for September the first, and formatted. I've tried setting the NumberFormat property to "Text" (or any other format), but that doesn't work because after the value was initially converted to a date, it cannot be converted back without returnning a number (The date seriel number I assume?).
Basically, I was wondering if there is a way to turn off this feature before I start outputting my data. Thanks in advance for the responses,

Cire

hi guys,

I have been playing with custom formats recently and I'm wondering if there is anyway to make them wrap?

specifically I have several results that I have been formatting to show what they are related to

397235 visitors 392648 visitors 365487 visitors

I want these to display as visitors, but still be numbers so that they can be summed etc.
The problem is that I need the text to wrap so that visitors is on the second line in the cell. unfortunatley all i get is a ########## error to show the cell is not wide enough even with wrap text turned on.

Any ideas?

I need to count the number of Carriage returns in a string of text in a group of merged cells also I need to add a carriage return after the 1024 character because I have the wrap text on. My overall goal is have copy text fit into a group of merged cells without any being cut off by excel.

I have a datasheet which I format to remove Wrap Text and then autofit the columns so I can see all details within the cells.

When I pivot this sheet, the resulting pivot table wraps the text again. If I take Wrap Text off and autofit again, then drill through onto a figure, the new datasheet created wraps the text again...

I didn't have this problem when I exported to Excel from a custom-built database; now we're exporting from a Reporting Services SQL report.

I've tried various combinations of Preserve Formatting but to no avail.

Do I have an Excel problem, a Reporting Services problem or a bit of both??

Hi,

Is it possible to turn off that error message that comes up as a little green triangle in the top left hand corner of a cell? The error message usually says something like "Inconsistent formula" or "Convert text that look like numbers"?

Cheers...

Hi Everyone - I have been searching the message board trying to find an answer to my problem, but unfortunately, I have had no luck. I could have missed it, so I apologize if the answer is out there already.

Here is my situation: I am using Excel, version 2003. I have the entire sheet formatted to wrap text. I enter text in cells, which wraps correctly. Before I print, I select the entire sheet and auto-fit the row height to make sure all the cells are big enough for the text in them. All the text shows up like it will print, but when I go to print preview, it cuts off the last line of text in some of the cells.

I have tried the Alt+Enter after the text, which works okay, but I have multiple pages of information and it would be a headache to do this to each cell. And to make matters worse, I am only setting up this spreadsheet (right now it is a 12 page table in Word), a person that has never used Excel is going to be doing the typing, so I am trying to make it as easy as possible.

I hope this all makes sense! Sorry for the lengthly message, but I tried to cover everything. Thanks!


No luck finding an answer? You could always try Google.