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