Selecting AutoFit

G

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,
 
G

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
 
G

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
 
G

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
 
G

GLMoore

Thanks once again -- most helpful!
GLM

Gord Dibben said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top