Autoformat List 1 header.

[Guest]

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.

 

[Gord Dibben]

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