software

Often when i double click on the extreme Left hand row, the column hieght
gets adjusted to its contents. However i have found that this does not apply
to few of the cells.. For eg. in my case the cells having data in BOLD were
not being adjusted to its height(even if content of these cells is having
less data limited to 6 words). I have used the word-wrap feature throughout
the sheet. i had to manually drag the cell hieght in such cases... I have
over 4000 rows filled in my excel sheet. is there any way to adjust the
column hieght of the cells automatically by selecting all rows amp; double
clicking it?

Alternatively, does anyone have a macro for setting this format?

Thanks,
Chitra

chits

Sounds like a few rows were manually set to a height.

These will not autofit until you select them and Formatgt;Rowgt;Autofit.

Easiest is to just select all rows and Formatgt;Rowgt;Autofit.

Now the double-click should work for all rows.Gord Dibben Excel MVP

On Sat, 24 Dec 2005 00:40:02 -0800, quot;chitsquot; gt;
wrote:

gt;Often when i double click on the extreme Left hand row, the column hieght
gt;gets adjusted to its contents. However i have found that this does not apply
gt;to few of the cells.. For eg. in my case the cells having data in BOLD were
gt;not being adjusted to its height(even if content of these cells is having
gt;less data limited to 6 words). I have used the word-wrap feature throughout
gt;the sheet. i had to manually drag the cell hieght in such cases... I have
gt;over 4000 rows filled in my excel sheet. is there any way to adjust the
gt;column hieght of the cells automatically by selecting all rows amp; double
gt;clicking it?
gt;
gt;Alternatively, does anyone have a macro for setting this format?
gt;
gt;Thanks,
gt;Chitra

Hi,

i have tried this option. But however this did not work. how do we reset
hieght of the cells that were manually set earlier? Even after clicking
Formatgt;Rowgt;Autofit -gt; the cell content is seen partly hidden..This is only
for few cells

I am using Microsofy Office Excel 2003 (11.5612.5606)
can you suggest me if this is a bug?.. any resolutions for this..

- Chitra

quot;Gord Dibbenquot; wrote:

gt; chits
gt;
gt; Sounds like a few rows were manually set to a height.
gt;
gt; These will not autofit until you select them and Formatgt;Rowgt;Autofit.
gt;
gt; Easiest is to just select all rows and Formatgt;Rowgt;Autofit.
gt;
gt; Now the double-click should work for all rows.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Sat, 24 Dec 2005 00:40:02 -0800, quot;chitsquot; gt;
gt; wrote:
gt;
gt; gt;Often when i double click on the extreme Left hand row, the column hieght
gt; gt;gets adjusted to its contents. However i have found that this does not apply
gt; gt;to few of the cells.. For eg. in my case the cells having data in BOLD were
gt; gt;not being adjusted to its height(even if content of these cells is having
gt; gt;less data limited to 6 words). I have used the word-wrap feature throughout
gt; gt;the sheet. i had to manually drag the cell hieght in such cases... I have
gt; gt;over 4000 rows filled in my excel sheet. is there any way to adjust the
gt; gt;column hieght of the cells automatically by selecting all rows amp; double
gt; gt;clicking it?
gt; gt;
gt; gt;Alternatively, does anyone have a macro for setting this format?
gt; gt;
gt; gt;Thanks,
gt; gt;Chitra
gt;