Formatting excel

[chits]

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 & double
clicking it?

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

Thanks,
Chitra

[Gord Dibben]

chits

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

These will not autofit until you select them and Format>Row>Autofit.

Easiest is to just select all rows and Format>Row>Autofit.

Now the double-click should work for all rows.


Gord Dibben Excel MVP

On Sat, 24 Dec 2005 00:40:02 -0800, "chits" <chits@discussions.microsoft.com>
wrote:

>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 & double
>clicking it?
>
>Alternatively, does anyone have a macro for setting this format?
>
>Thanks,
>Chitra

[chits]

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
Format>Row>Autofit -> 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

"Gord Dibben" wrote:

> chits
>
> Sounds like a few rows were manually set to a height.
>
> These will not autofit until you select them and Format>Row>Autofit.
>
> Easiest is to just select all rows and Format>Row>Autofit.
>
> Now the double-click should work for all rows.
>
>
> Gord Dibben Excel MVP
>
> On Sat, 24 Dec 2005 00:40:02 -0800, "chits" <chits@discussions.microsoft.com>
> wrote:
>
> >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 & double
> >clicking it?
> >
> >Alternatively, does anyone have a macro for setting this format?
> >
> >Thanks,
> >Chitra
>