Selecting AutoFit

[GLMoore]

I've been reading the many posts on the pitfalls of Merged Cells (Thanks,
Gordon!) and use of Format>Columns/Rows>AutoFit 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,

 

[Gord Dibben]

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

 

[GLMoore]

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]

Not a toggle.

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


Gord

 

[GLMoore]

Thanks once again -- most helpful!
GLM

Not a toggle.

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


Gord