Stop cells from automatically shading

[jlhudg23]

Problem: I have a few contiguous cells (below each other in same column) that are shaded (fill color). When I enter text/data/whatever in the next cell down and hit [ENTER], the cell I just entered text/data/whatever into automatically shades to the same color as the few cells above. I want to stop this madness. And I would prefer not to have to run any macros, VBA, etc.

Thanks.

 

[pagrender]

If you're using 2007, go to Excel Options, on the Advanced Tab and the Editing Options section, uncheck the "Extend Data Range and Formats" option.

I don't have 2003 so I don't know exactly how to turn it off in that version.

Pete

 

[jlhudg23]

Sorry, should have stated: this occurs in Excel 2003 (at work) and Excel 2000 (at home).