When I use List 1 in Autoformat, it sometimes treats the first two rows of
data (rows 2 and 3) as header. Only the first row is header. It doesn't
always do this but sometimes and usually clearing autoformat and
re-autoformatting fixes it but it isn't fixing it today! Thanks for any help.

My Excel 2002 and 2003 List1 always shades the top two rows.

Instead of using the Autoformat you should try Conditional Formatting to shade
alternate rows.

That way, inserting or deleting rows will not affect the alternate shading.

See Chip Pearson's "banding with CF"

http://www.cpearson.com/excel/banding.htm


Gord Dibben Excel MVP


On Mon, 9 May 2005 14:40:03 -0700, janelbrown12
wrote:

When I use List 1 in Autoformat, it sometimes treats the first two rows of
data (rows 2 and 3) as header. Only the first row is header. It doesn't
always do this but sometimes and usually clearing autoformat and
re-autoformatting fixes it but it isn't fixing it today! Thanks for any help.