Alternate rows shaded in Excel
I don't think much of the Microsoft Office help system, so perhaps someone here could help.
In Excel (Office 2011) I want to create a spreadsheet where alternate rows are shaded, say in blue, the others being white. This is to help readability with long rows. I know that this can be done because Excel offers several templates (see pic) but my Visual Quickstart Guide is no help. I could do it manually, but the later insertion of rows would require all later rows to be re-shaded. The template has an automatic formatting feature where the rows keep their alternate shadings (I was able to demonstrate that). Perhaps if someone has an earlier versions of Excel, it could give a clue.
Can anyone help please?