Configure alternate row shading in Excel 2011 for Mac This lesson shows you a quick and easy way to do it on Excel 2011 for Mac. There are a number of ways you can achieve this. If you are working with large tables of data in Excel, you can make your spreadsheet easier to read by formatting alternate rows to be shaded a different colour.