wrapping text

J

Jerry

I am running windows XP SP2 with Office 2000 SP2 I have a spreadsheet in
Excel and I have one cell I'm trying to wrap the text in so the text will fit
in the cell but it's not working, some of the text is hidden in the cell
unless I drag the cell block way over to expose the text contents. Anyone
have any ideas or suggestions?

Thanks
 
G

Gord Dibben

Format>Row>Autofit?

Perhaps the cell is the result of merging two or more cells?

Autofit does not work in this case and requires a macro.


Gord Dibben MS Excel MVP
 
J

Jerry

Thanks for responding, I didn't merge two cells, the odd part is the other
cells work fine.
 
G

Gord Dibben

A cell by itself cannot change height because a cell is a member of a row and
the entire row must increase or decrease.

Did you try the Autofit when selecting that row.


Gord

Thanks for responding, I didn't merge two cells, the odd part is the other
cells work fine.
Click to expand...

Gord Dibben MS Excel MVP
 
J

Jerry

under format cells, then alignment, I do not see an auto fit option. I
highlighted the whole column and tried to edit it but like I said, there is
no auto fit option. Thanks again.
 
R

RagDyeR

Select a row(s), then, on the toolbar:
<Format> <Row> <Autofit>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

under format cells, then alignment, I do not see an auto fit option. I
highlighted the whole column and tried to edit it but like I said, there is
no auto fit option. Thanks again.
 
J

Jerry

Thanks for helping out, I tried what you suggested but it still didn't work,
I don't know what the heck is happening to this one cell, all the others work
fine with wrap text.
 
M

MartinW

Hi Jerry,

Has that cell by any chance got an indent set in it
under Format>Cells>Alignment

Just a thought
Martin
 
J

Jerry

Thanks for responding Martin, I checked the cell / cells, there is no indent
set. Another odd part is the wrap text option is checked but it's grayed out
now, I cannot uncheck that box.
 
J

Jerry

Thanks for responding RD, the cell isn't protected neither is the
spreadsheet, however, the document is shared, I edit the sheet then use my
briefcase to update to my desktop computer from my notebook. Like I said, the
odd part is it's only this one cell that is acting up.
 
Top