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,