Formatting not staying on
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.
|