EXCEL WORKSHEET TWEAK 2

[junior1r]

Is there a way to automatically make each line on a worksheet an alternate color so that it is easier to view

 

[carrr]

See thread68-139953

 

[cwinnyk]

Try highlighting the rows you want to alternate, and then do Format, Autoformat, and see if there's a format style that suits your tastes.

Chris

 

[sdraper]

Chip Pearson takes this technique to the next level

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

BTW The site above is an AWESOME
excel resource!
hope this helps!

Sam