Two useful Excel tricks

I used to be utilizing Excel at present and discover that I have to do two issues. The primary one is to routinely alternate row colours (one shaded, one white), so I searched on-line and located this tutorial very helpful.

http://www.techonthenet.com/excel/questions/cond_format2.php


And the opposite factor I want to do is to create an inventory from knowledge validation, so in every cell of 1 column, I can choose the automotive makers. And I want to use the subsequent column to report the automotive mannequin, which imply the second listing depends on the number of earlier cell's enter. I searched on-line and located that it's referred to as : dependent listing for knowledge validation. This is the tutorial that I adopted:

http://www.contextures.com/xlDataVal02.html

Very useful!