Select the Fill Color: Choose the fill color button from the Excel toolbar. Pick a color from the palette, such as red, and start filling in the individual cells to create your design.

In Excel 2007, choose Go To Special from the Find and Select dropdown list in the Editing group on the Home tab. Select Blanks. When you click OK, Excel will select all the blank cells in A2:A11.

Click the fill handle and drag it down until you cover the desired rage of cells in the column, and then release the mouse button. Excel copies the value in the first cell to the other cells. More ...