I should perhaps have said that the formatting is being applied to the second
of 6 sheets. I type on the 2nd one and the data is copied to sheets 3 - 6.
Thanks again.

"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.