Maybe because I left out the part about also setting "Wrap Text" at the same
time.

If the sheets are still grouped, whatever you type on the activesheet will also
be entered in the other sheets.

BTW..........if any merged cells, these will not autofit.


Gord

On Wed, 13 Feb 2008 03:21:02 -0800, AnnP wrote:

Many thanks for your reply. I did as you suggest and applied Autofit to the
appropriate cells on the appropriate sheets and saved the template. When I
type on the first sheet, the Autofit works, but not on the other sheets. Any
further suggestions?


"Gord Dibben" wrote:

Autofit is a sheet only setting.

Must be set on each sheet.

Quick way to do this select first sheet then right-click on a sheet tab and
"Select all Sheets"

CTRL + a to select all cells.

FormatRowAutofit.

Right-click on a sheet tab to "ungroup" the sheets.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 03:26:00 -0800, AnnP wrote:

I have some cells with Autofit ON on the first sheet of my workbook. I want
the same formatting on the other 4 sheets, but even although I have
individually applied Autofit to the cells I want, it does not see this
formatting. The idea is for all the sheets to mimick the first sheet.

Any help would be appreciated.