I am typing text in a cell and want it to wrap. I checked "wrap text" box
however it still doesn't wrap and I can only see part of the text. When I
click on the cell the text is there, but I still can't view it if I'm not in
that specific cell.
I am typing text in a cell and want it to wrap. I checked "wrap text" box
however it still doesn't wrap and I can only see part of the text. When I
click on the cell the text is there, but I still can't view it if I'm not in
that specific cell.
Is your cell high enough? Try making your cell hight a bit taller. Excel
should automatically adjust the cell height, but that's not always the case.
X_HOBBES
"rohrbaught" <[email protected]> wrote in message
news:[email protected]...
> I am typing text in a cell and want it to wrap. I checked "wrap text" box
> however it still doesn't wrap and I can only see part of the text. When I
> click on the cell the text is there, but I still can't view it if I'm not
in
> that specific cell.
Move the mouse to the row number on the left and double-clik on the
bottom border. The row height will auto adjust.
rohrbaught shared this with us in microsoft.public.excel.misc:
> I am typing text in a cell and want it to wrap. I checked "wrap
> text" box however it still doesn't wrap and I can only see part of
> the text. When I click on the cell the text is there, but I still
> can't view it if I'm not in that specific cell.
Press ALT+Enter to insert new lines in the same cell.
--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?
How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html
You are exactly right...I expanded the height with my cursor and sure enough
the "hidden" text appeared. Thanks!
"X_HOBBES" wrote:
> Is your cell high enough? Try making your cell hight a bit taller. Excel
> should automatically adjust the cell height, but that's not always the case.
>
> X_HOBBES
>
>
> "rohrbaught" <[email protected]> wrote in message
> news:[email protected]...
> > I am typing text in a cell and want it to wrap. I checked "wrap text" box
> > however it still doesn't wrap and I can only see part of the text. When I
> > click on the cell the text is there, but I still can't view it if I'm not
> in
> > that specific cell.
>
>
>
Sorry, I wasn't able to follow your instructions.
"P Sitaram" wrote:
> Move the mouse to the row number on the left and double-clik on the
> bottom border. The row height will auto adjust.
>
>
Thanks for responding...I tried this and did not work.
"Amedee Van Gasse" wrote:
> rohrbaught shared this with us in microsoft.public.excel.misc:
>
> > I am typing text in a cell and want it to wrap. I checked "wrap
> > text" box however it still doesn't wrap and I can only see part of
> > the text. When I click on the cell the text is there, but I still
> > can't view it if I'm not in that specific cell.
>
> Press ALT+Enter to insert new lines in the same cell.
>
> --
> Amedee Van Gasse using XanaNews 1.17.3.1
> If it has an "X" in the name, it must be Linux?
>
> How To Ask Questions The Smart Way
> http://www.catb.org/~esr/faqs/smart-questions.html
> How to Report Bugs Effectively
> http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
> Only ask questions with yes/no answers if you want "yes" or "no" as the
> answer.
> http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
> o-answers.html
>
rohrbaught shared this with us in microsoft.public.excel.misc:
> Thanks for responding...I tried this and did not work.
I'm sorry to hear that. It works for me.
Please note that this does not make the line wrap, it just adds hard
coded line breaks. Please follow Hobbes' instructions.
--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?
How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html
You also need to make sure your cell is set to wrap. Right click on
cell. Click format. Alignment tab. Check "Wrap Text"
...try putting a single cell to the right (of width equal to the sum of all the merged cells with the wrap problem and with word wrap ticked - best to format the same).
Then make this cell equal the merged cell (e.g. "=C3").
The autofit should now work.
I had similar problem. I had a table with many columns and rows with text. Wrap text option didn't work but I wanted to print directly from Excel.
My solution was this. I selected whole column and clicked Wrap text button and it WORKED. I tried to select more columns at same time and it WORKED. When I select whole table it didn't work.
I tried all of the suggested fixes and none worked for me. My worksheet had data that was converted from a pdf spreadsheet. It had cells that been merged, then unmerged and text Concantonated, date times split to date column and time columns, etc.
I even had some cells in a column where the text would center ok and the in the next row the text would not center no matter what formatting I tried.
The only thing that ended up working was to:
1) Save the sheet as a comma delineated file.
2) Close it.
3) Open it.
It now has all the data back in default formatting - no wrapping, not autofit.
I was then able to select columns and set Word Wrap. Select other columns and select Autofit. Select the entire worksheet and Autofit rows. Change fonts and font sizes.
I had the same problem. First, select the all the cells you're having the issue with. Then click Home tab. Then click Format tab. Then select row, then autofit.
This worked for me. Now all the rows show the wrapped text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks