I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!

Are the cells "merged"?

Merged cells with wrap text won't Autofit.

You need VBA event code to get the autofit.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP



On Tue, 10 Mar 2009 09:27:00 -0700, KristinQ
wrote:

I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!

Thanks for the response, Gord. My cells weren't merged, but the header cells
over them in Row 1 were. I deleted the merged cells, saved all as a new
document and tried again. Still didn't work.

I then selected all and unchecked the "Wrap Text" box so it's back on the
normal wrap setting. That put all the rows at one-line height. I then
selected all and did Format/AutoFit Row Height. Still not working.

I'm not a developer, but tried that link you sent. I tried the code from
both MarkN and Greg Wilson using the VB window for each sheet. Nothing
happened, so I tried the Format/AutoFit Row Height command again after
pasting the VB code, but nothing seemed different. I don't really know how
to use VB though, so I'm sure it's user error.

It doesn't seem to make sense that as a layman I would need to know how to
use VB code just to make the rows AutoFit....I think I'm missing something.

Thanks for trying to help.


"Gord Dibben" wrote:

Are the cells "merged"?

Merged cells with wrap text won't Autofit.

You need VBA event code to get the autofit.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP



On Tue, 10 Mar 2009 09:27:00 -0700, KristinQ
wrote:

I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!

With Target
If .MergeCells And .WrapText Then

If you have no merged cells, the code will do nothing so might as well
delete the code from your sheet.

In order for Autofit to work properly, the cells must be set to Wrap Text.

Select all and set to Wrap Text.

Select all rows and set to Autofit.


Gord

On Tue, 10 Mar 2009 13:43:03 -0700, KristinQ
wrote:

Thanks for the response, Gord. My cells weren't merged, but the header cells
over them in Row 1 were. I deleted the merged cells, saved all as a new
document and tried again. Still didn't work.

I then selected all and unchecked the "Wrap Text" box so it's back on the
normal wrap setting. That put all the rows at one-line height. I then
selected all and did Format/AutoFit Row Height. Still not working.

I'm not a developer, but tried that link you sent. I tried the code from
both MarkN and Greg Wilson using the VB window for each sheet. Nothing
happened, so I tried the Format/AutoFit Row Height command again after
pasting the VB code, but nothing seemed different. I don't really know how
to use VB though, so I'm sure it's user error.

It doesn't seem to make sense that as a layman I would need to know how to
use VB code just to make the rows AutoFit....I think I'm missing something.

Thanks for trying to help.


"Gord Dibben" wrote:

Are the cells "merged"?

Merged cells with wrap text won't Autofit.

You need VBA event code to get the autofit.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP



On Tue, 10 Mar 2009 09:27:00 -0700, KristinQ
wrote:

I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!

Still doesn't work. I think my workbook is broken. I'll probably be bettter
off starting from scratch with a new one. Those features all work properly
when I open a new workbook and play with the cells, so there must be
something wrong with my data. Ugh.

Thanks again.


"Gord Dibben" wrote:

With Target
If .MergeCells And .WrapText Then

If you have no merged cells, the code will do nothing so might as well
delete the code from your sheet.

In order for Autofit to work properly, the cells must be set to Wrap Text.

Select all and set to Wrap Text.

Select all rows and set to Autofit.


Gord

On Tue, 10 Mar 2009 13:43:03 -0700, KristinQ
wrote:

Thanks for the response, Gord. My cells weren't merged, but the header cells
over them in Row 1 were. I deleted the merged cells, saved all as a new
document and tried again. Still didn't work.

I then selected all and unchecked the "Wrap Text" box so it's back on the
normal wrap setting. That put all the rows at one-line height. I then
selected all and did Format/AutoFit Row Height. Still not working.

I'm not a developer, but tried that link you sent. I tried the code from
both MarkN and Greg Wilson using the VB window for each sheet. Nothing
happened, so I tried the Format/AutoFit Row Height command again after
pasting the VB code, but nothing seemed different. I don't really know how
to use VB though, so I'm sure it's user error.

It doesn't seem to make sense that as a layman I would need to know how to
use VB code just to make the rows AutoFit....I think I'm missing something.

Thanks for trying to help.


"Gord Dibben" wrote:

Are the cells "merged"?

Merged cells with wrap text won't Autofit.

You need VBA event code to get the autofit.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP



On Tue, 10 Mar 2009 09:27:00 -0700, KristinQ
wrote:

I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!

Good luck.


Gord

On Wed, 11 Mar 2009 10:12:04 -0700, KristinQ
wrote:

Still doesn't work. I think my workbook is broken. I'll probably be bettter
off starting from scratch with a new one. Those features all work properly
when I open a new workbook and play with the cells, so there must be
something wrong with my data. Ugh.

Thanks again.


"Gord Dibben" wrote:

With Target
If .MergeCells And .WrapText Then

If you have no merged cells, the code will do nothing so might as well
delete the code from your sheet.

In order for Autofit to work properly, the cells must be set to Wrap Text.

Select all and set to Wrap Text.

Select all rows and set to Autofit.


Gord

On Tue, 10 Mar 2009 13:43:03 -0700, KristinQ
wrote:

Thanks for the response, Gord. My cells weren't merged, but the header cells
over them in Row 1 were. I deleted the merged cells, saved all as a new
document and tried again. Still didn't work.

I then selected all and unchecked the "Wrap Text" box so it's back on the
normal wrap setting. That put all the rows at one-line height. I then
selected all and did Format/AutoFit Row Height. Still not working.

I'm not a developer, but tried that link you sent. I tried the code from
both MarkN and Greg Wilson using the VB window for each sheet. Nothing
happened, so I tried the Format/AutoFit Row Height command again after
pasting the VB code, but nothing seemed different. I don't really know how
to use VB though, so I'm sure it's user error.

It doesn't seem to make sense that as a layman I would need to know how to
use VB code just to make the rows AutoFit....I think I'm missing something.

Thanks for trying to help.


"Gord Dibben" wrote:

Are the cells "merged"?

Merged cells with wrap text won't Autofit.

You need VBA event code to get the autofit.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP



On Tue, 10 Mar 2009 09:27:00 -0700, KristinQ
wrote:

I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!