I've been reading the many posts on the pitfalls of Merged Cells (Thanks,
Gordon!) and use of FormatColumns/RowsAutoFit instead. Here's my question:

In Excel 2003, how do you know when AutoFit (or either Rows, Columns or
both) has been applied to a cell?

In many MS applications, when you choose one of the items on a drop-down
from the menu bar, that choice will be reflected because next time the
dropdown is opened, there will be a checkmark or some other visible selection
indication.

But in Excel 2003, if I format a cell with AutoFit, and then go back to that
cell, there's no indication that the AutoFit formatting has been applied to
that cell. Am I just missing how to tell whether the formatting has been
applied?

Thanks,

I do not know of any way to see/tell if a row or column has been set to
autofit.


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 06:52:05 -0800, GLMoore
wrote:

I've been reading the many posts on the pitfalls of Merged Cells (Thanks,
Gordon!) and use of FormatColumns/RowsAutoFit instead. Here's my question:

In Excel 2003, how do you know when AutoFit (or either Rows, Columns or
both) has been applied to a cell?

In many MS applications, when you choose one of the items on a drop-down
from the menu bar, that choice will be reflected because next time the
dropdown is opened, there will be a checkmark or some other visible selection
indication.

But in Excel 2003, if I format a cell with AutoFit, and then go back to that
cell, there's no indication that the AutoFit formatting has been applied to
that cell. Am I just missing how to tell whether the formatting has been
applied?

Thanks,

Thanks for the confirmation, Gordon -- last question: is that a toggle? If
I've applied it, don't remember that I did and so click the option again, am
I turning it off?

Thanks again for the assistance.
GLM


"Gord Dibben" wrote:

I do not know of any way to see/tell if a row or column has been set to
autofit.


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 06:52:05 -0800, GLMoore
wrote:

I've been reading the many posts on the pitfalls of Merged Cells (Thanks,
Gordon!) and use of FormatColumns/RowsAutoFit instead. Here's my question:

In Excel 2003, how do you know when AutoFit (or either Rows, Columns or
both) has been applied to a cell?

In many MS applications, when you choose one of the items on a drop-down
from the menu bar, that choice will be reflected because next time the
dropdown is opened, there will be a checkmark or some other visible selection
indication.

But in Excel 2003, if I format a cell with AutoFit, and then go back to that
cell, there's no indication that the AutoFit formatting has been applied to
that cell. Am I just missing how to tell whether the formatting has been
applied?

Thanks,

Not a toggle.

Once autofit is enabled, if you manually re-size a row or column, you have
to reset to autofit via formatrowautofit because the manual resize removes
the autofit.


Gord

On Wed, 4 Feb 2009 09:51:06 -0800, GLMoore
wrote:

Thanks for the confirmation, Gordon -- last question: is that a toggle? If
I've applied it, don't remember that I did and so click the option again, am
I turning it off?

Thanks again for the assistance.
GLM


"Gord Dibben" wrote:

I do not know of any way to see/tell if a row or column has been set to
autofit.


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 06:52:05 -0800, GLMoore
wrote:

I've been reading the many posts on the pitfalls of Merged Cells (Thanks,
Gordon!) and use of FormatColumns/RowsAutoFit instead. Here's my question:

In Excel 2003, how do you know when AutoFit (or either Rows, Columns or
both) has been applied to a cell?

In many MS applications, when you choose one of the items on a drop-down
from the menu bar, that choice will be reflected because next time the
dropdown is opened, there will be a checkmark or some other visible selection
indication.

But in Excel 2003, if I format a cell with AutoFit, and then go back to that
cell, there's no indication that the AutoFit formatting has been applied to
that cell. Am I just missing how to tell whether the formatting has been
applied?

Thanks,

Thanks once again -- most helpful!
GLM

"Gord Dibben" wrote:

Not a toggle.

Once autofit is enabled, if you manually re-size a row or column, you have
to reset to autofit via formatrowautofit because the manual resize removes
the autofit.


Gord

On Wed, 4 Feb 2009 09:51:06 -0800, GLMoore
wrote:

Thanks for the confirmation, Gordon -- last question: is that a toggle? If
I've applied it, don't remember that I did and so click the option again, am
I turning it off?

Thanks again for the assistance.
GLM


"Gord Dibben" wrote:

I do not know of any way to see/tell if a row or column has been set to
autofit.


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 06:52:05 -0800, GLMoore
wrote:

I've been reading the many posts on the pitfalls of Merged Cells (Thanks,
Gordon!) and use of FormatColumns/RowsAutoFit instead. Here's my question:

In Excel 2003, how do you know when AutoFit (or either Rows, Columns or
both) has been applied to a cell?

In many MS applications, when you choose one of the items on a drop-down
from the menu bar, that choice will be reflected because next time the
dropdown is opened, there will be a checkmark or some other visible selection
indication.

But in Excel 2003, if I format a cell with AutoFit, and then go back to that
cell, there's no indication that the AutoFit formatting has been applied to
that cell. Am I just missing how to tell whether the formatting has been
applied?

Thanks,