wrapping text

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

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

On Sat, 1 Jul 2006 09:50:01 -0700, Jerry <Jerry@discussions.microsoft.com>
wrote:

>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

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

"Gord Dibben" wrote:

> 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
>
> On Sat, 1 Jul 2006 09:50:01 -0700, Jerry <Jerry@discussions.microsoft.com>
> wrote:
>
> >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
>
>

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

On Sat, 1 Jul 2006 10:27:02 -0700, Jerry <Jerry@discussions.microsoft.com>
wrote:

>Thanks for responding, I didn't merge two cells, the odd part is the other
>cells work fine.
>
>"Gord Dibben" wrote:
>
>> 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
>>
>> On Sat, 1 Jul 2006 09:50:01 -0700, Jerry <Jerry@discussions.microsoft.com>
>> wrote:
>>
>> >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
>>
>>

Gord Dibben MS Excel MVP

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.

"Gord Dibben" wrote:

> 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
>
> On Sat, 1 Jul 2006 10:27:02 -0700, Jerry <Jerry@discussions.microsoft.com>
> wrote:
>
> >Thanks for responding, I didn't merge two cells, the odd part is the other
> >cells work fine.
> >
> >"Gord Dibben" wrote:
> >
> >> 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
> >>
> >> On Sat, 1 Jul 2006 09:50:01 -0700, Jerry <Jerry@discussions.microsoft.com>
> >> wrote:
> >>
> >> >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
> >>
> >>
>
> Gord Dibben MS Excel MVP
>

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

HTH,

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

"Jerry" <Jerry@discussions.microsoft.com> wrote in message
news:200C1BA1-3BC3-4DBD-9D5B-4E3C33045C9E@microsoft.com...
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.

"Gord Dibben" wrote:

> 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
>
> On Sat, 1 Jul 2006 10:27:02 -0700, Jerry <Jerry@discussions.microsoft.com>
> wrote:
>
> >Thanks for responding, I didn't merge two cells, the odd part is the
other
> >cells work fine.
> >
> >"Gord Dibben" wrote:
> >
> >> 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
> >>
> >> On Sat, 1 Jul 2006 09:50:01 -0700, Jerry
<Jerry@discussions.microsoft.com>
> >> wrote:
> >>
> >> >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
> >>
> >>
>
> Gord Dibben MS Excel MVP
>

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.

"RagDyeR" wrote:

> Select a row(s), then, on the toolbar:
> <Format> <Row> <Autofit>
> --
>
> HTH,
>
> RD
> =====================================================
> Please keep all correspondence within the Group, so all may benefit!
> =====================================================
>
> "Jerry" <Jerry@discussions.microsoft.com> wrote in message
> news:200C1BA1-3BC3-4DBD-9D5B-4E3C33045C9E@microsoft.com...
> 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.
>
> "Gord Dibben" wrote:
>
> > 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
> >
> > On Sat, 1 Jul 2006 10:27:02 -0700, Jerry <Jerry@discussions.microsoft.com>
> > wrote:
> >
> > >Thanks for responding, I didn't merge two cells, the odd part is the
> other
> > >cells work fine.
> > >
> > >"Gord Dibben" wrote:
> > >
> > >> 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
> > >>
> > >> On Sat, 1 Jul 2006 09:50:01 -0700, Jerry
> <Jerry@discussions.microsoft.com>
> > >> wrote:
> > >>
> > >> >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
> > >>
> > >>
> >
> > Gord Dibben MS Excel MVP
> >
>
>
>

Hi Jerry,

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

Just a thought
Martin

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.

"MartinW" wrote:

> Hi Jerry,
>
> Has that cell by any chance got an indent set in it
> under Format>Cells>Alignment
>
> Just a thought
> Martin
>
>
>

Is the sheet protected or shared?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jerry" <Jerry@discussions.microsoft.com> wrote in message
news:D9CD9BBA-4504-4ECF-8D94-49480695F0D8@microsoft.com...
> 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.
>
> "MartinW" wrote:
>
> > Hi Jerry,
> >
> > Has that cell by any chance got an indent set in it
> > under Format>Cells>Alignment
> >
> > Just a thought
> > Martin
> >
> >
> >

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.

"Ragdyer" wrote:

> Is the sheet protected or shared?
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Jerry" <Jerry@discussions.microsoft.com> wrote in message
> news:D9CD9BBA-4504-4ECF-8D94-49480695F0D8@microsoft.com...
> > 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.
> >
> > "MartinW" wrote:
> >
> > > Hi Jerry,
> > >
> > > Has that cell by any chance got an indent set in it
> > > under Format>Cells>Alignment
> > >
> > > Just a thought
> > > Martin
> > >
> > >
> > >
>
>