Colour+highlight+alternate+cells+in+Excel


 * Colour highlight alternate cells in Excel **

MS Excel with a highlighted colour. If you use Excel 2007? First, **highlight** the section of the worksheet you need to format. On the **Home** ribbon, you are looking for the **Format as Table** button.

Excel will then confirm that the highlighted range of cells should be converted to a table. Click **OK**. You will then be returned to your worksheet, where you'll find that Excel has turned your highlighted range into a table.
 * Select the formatting** of your choice.

The header row you see can be removed by **unchecking "Header Row"** in the **Table Style Options** section of the **Table Tools Design** ribbon.

Finally, you will return the cells to a normal worksheet. First, make sure you have a cell of the table selected. Now, click the **Convert to Range** button (also located on the Table Tools Design ribbon). Voila! Highlighting every other row, without all the manual work!