1. Open the spreadsheet you want to shade the rows of in Excel.
2. Hold the 'Ctrl' key on your keyboard and press 'A,' releasing both keys.
3. Click 'Home' on the top menu in Excel 2007.
4. Click 'Format as Table' under 'Styles' and click 'OK.' This shades the rows for you automatically.