I have since found that this is a bug in Excel 2003. Thanks for replies.

"AnnP" wrote:

Thanks, but I did have Wrap Text on, no merged cells and ungrouped the
sheets. I even tried using a macro to apply the Autofit to the appropriate
cells after the text is typed, but that did not work either. Funnily enough,
if I manually select the cells after entering the text and apply Autofit, it
does work! I really didn't want the users to have to manually apply Autofit,
so am looking for another way round this.

Sorry to be a pain, but this is very frustrating.

"Gord Dibben" wrote:

That is normal behaviour for "grouped sheets".

Ungroup to prevent that.


Gord

On Wed, 13 Feb 2008 03:25:00 -0800, AnnP wrote:

I type on the 2nd one and the data is copied to sheets 3 - 6.