Aug 4, 2017 - There are 2 ways of doing this on Excel for Mac. AutoFormat does not automatically correct the shading to alternate every other row so you.

I don't think much of the Microsoft Office help system, so perhaps someone here could help. Best mac apps for photo editing. 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? Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.

All postings and use of the content on this site are subject to the.