So I've used "wrap text" and I've used "Row - auto fit" and I still have text
that is not showing up in the cell. I have 2800 lines and I'm going to have
to go through individually and make sure they are all the right height.
There has to be a simpler way.

Please help. I'm desperate.

Thanks.

Cells.AutoFit
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"suestew" wrote:

> So I've used "wrap text" and I've used "Row - auto fit" and I still have text
> that is not showing up in the cell. I have 2800 lines and I'm going to have
> to go through individually and make sure they are all the right height.
> There has to be a simpler way.
>
> Please help. I'm desperate.
>
> Thanks.

Sorry,
I meant: Cells.Rows.AutoFit

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Michael" wrote:

> Cells.AutoFit
> --
> If this posting was helpful, please click on the Yes button.
> Regards,
>
> Michael Arch.
>
>
>
>
> "suestew" wrote:
>
> > So I've used "wrap text" and I've used "Row - auto fit" and I still have text
> > that is not showing up in the cell. I have 2800 lines and I'm going to have
> > to go through individually and make sure they are all the right height.
> > There has to be a simpler way.
> >
> > Please help. I'm desperate.
> >
> > Thanks.

Is this a macro?

"Michael" wrote:

> Cells.AutoFit
> --
> If this posting was helpful, please click on the Yes button.
> Regards,
>
> Michael Arch.
>
>
>
>
> "suestew" wrote:
>
> > So I've used "wrap text" and I've used "Row - auto fit" and I still have text
> > that is not showing up in the cell. I have 2800 lines and I'm going to have
> > to go through individually and make sure they are all the right height.
> > There has to be a simpler way.
> >
> > Please help. I'm desperate.
> >
> > Thanks.

Sorry I'm so confused but are you sending me a macro or are you telling me
how to use the Excel functions?

If its the latter, I've already tried to use Row - auto fit and it's not
working.

thanks again for your help.

"Michael" wrote:

> Sorry,
> I meant: Cells.Rows.AutoFit
>
> --
> If this posting was helpful, please click on the Yes button.
> Regards,
>
> Michael Arch.
>
>
>
>
> "Michael" wrote:
>
> > Cells.AutoFit
> > --
> > If this posting was helpful, please click on the Yes button.
> > Regards,
> >
> > Michael Arch.
> >
> >
> >
> >
> > "suestew" wrote:
> >
> > > So I've used "wrap text" and I've used "Row - auto fit" and I still have text
> > > that is not showing up in the cell. I have 2800 lines and I'm going to have
> > > to go through individually and make sure they are all the right height.
> > > There has to be a simpler way.
> > >
> > > Please help. I'm desperate.
> > >
> > > Thanks.

That is one line of a macro.
If you want to do this manually, select your entire range or select the
entire sheet. Then you can wrap it all, and/or autofit all the columns and
rows. HTH Otto
"suestew" <(E-Mail Removed)> wrote in message
news:64075961-AE0E-4DA1-A220-(E-Mail Removed)...
> Is this a macro?
>
> "Michael" wrote:
>
>> Cells.AutoFit
>> --
>> If this posting was helpful, please click on the Yes button.
>> Regards,
>>
>> Michael Arch.
>>
>>
>>
>>
>> "suestew" wrote:
>>
>> > So I've used "wrap text" and I've used "Row - auto fit" and I still
>> > have text
>> > that is not showing up in the cell. I have 2800 lines and I'm going to
>> > have
>> > to go through individually and make sure they are all the right height.
>> > There has to be a simpler way.
>> >
>> > Please help. I'm desperate.
>> >
>> > Thanks.

How much text is not showing up?

If you have more than 1024 characters in a cell Excel will display only the
first 1024.

Add an Alt + Enter every 80-100 chars.

Another thing..............if cells are merged, autofit will not work.

You would need event code to autofit any row with merged cells.


Gord Dibben MS Excel MVP

On Mon, 15 Dec 2008 09:55:01 -0800, suestew
<(E-Mail Removed)> wrote:

>So I've used "wrap text" and I've used "Row - auto fit" and I still have text
>that is not showing up in the cell. I have 2800 lines and I'm going to have
>to go through individually and make sure they are all the right height.
>There has to be a simpler way.
>
>Please help. I'm desperate.
>
>Thanks.

Thanks - your response was very helpful. I do have more than 1024 characters
in many of the cells. Now the question is, can I filter cells that have that
or more so I can adjust those by group rather than individually.

Thanks.

"Gord Dibben" wrote:

> How much text is not showing up?
>
> If you have more than 1024 characters in a cell Excel will display only the
> first 1024.
>
> Add an Alt + Enter every 80-100 chars.
>
> Another thing..............if cells are merged, autofit will not work.
>
> You would need event code to autofit any row with merged cells.
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 15 Dec 2008 09:55:01 -0800, suestew
> <(E-Mail Removed)> wrote:
>
> >So I've used "wrap text" and I've used "Row - auto fit" and I still have text
> >that is not showing up in the cell. I have 2800 lines and I'm going to have
> >to go through individually and make sure they are all the right height.
> >There has to be a simpler way.
> >
> >Please help. I'm desperate.
> >
> >Thanks.
>
>

Like data|autofilter???

If that's what you mean, you may want to read Debra Dalgleish's notes:
http://contextures.com/xlautofilter02.html#String



suestew wrote:
>
> Thanks - your response was very helpful. I do have more than 1024 characters
> in many of the cells. Now the question is, can I filter cells that have that
> or more so I can adjust those by group rather than individually.
>
> Thanks.
>
> "Gord Dibben" wrote:
>
> > How much text is not showing up?
> >
> > If you have more than 1024 characters in a cell Excel will display only the
> > first 1024.
> >
> > Add an Alt + Enter every 80-100 chars.
> >
> > Another thing..............if cells are merged, autofit will not work.
> >
> > You would need event code to autofit any row with merged cells.
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Mon, 15 Dec 2008 09:55:01 -0800, suestew
> > <(E-Mail Removed)> wrote:
> >
> > >So I've used "wrap text" and I've used "Row - auto fit" and I still have text
> > >that is not showing up in the cell. I have 2800 lines and I'm going to have
> > >to go through individually and make sure they are all the right height.
> > >There has to be a simpler way.
> > >
> > >Please help. I'm desperate.
> > >
> > >Thanks.
> >
> >

--

Dave Peterson

Assuming cells are in column A

In B1 enter =LEN(A1) and double-click fill handle to copy down.

Autofilter on column B for custom>greater than 1000


Gord

On Mon, 15 Dec 2008 11:44:09 -0800, suestew
<(E-Mail Removed)> wrote:

>Thanks - your response was very helpful. I do have more than 1024 characters
>in many of the cells. Now the question is, can I filter cells that have that
>or more so I can adjust those by group rather than individually.
>
>Thanks.
>
>"Gord Dibben" wrote:
>
>> How much text is not showing up?
>>
>> If you have more than 1024 characters in a cell Excel will display only the
>> first 1024.
>>
>> Add an Alt + Enter every 80-100 chars.
>>
>> Another thing..............if cells are merged, autofit will not work.
>>
>> You would need event code to autofit any row with merged cells.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Mon, 15 Dec 2008 09:55:01 -0800, suestew
>> <(E-Mail Removed)> wrote:
>>
>> >So I've used "wrap text" and I've used "Row - auto fit" and I still have text
>> >that is not showing up in the cell. I have 2800 lines and I'm going to have
>> >to go through individually and make sure they are all the right height.
>> >There has to be a simpler way.
>> >
>> >Please help. I'm desperate.
>> >
>> >Thanks.
>>
>>