Select the range of cells you want to format with alternat row shading.Ĭlick the Conditional Formatting button on the Home menu It is a bit convoluted, but works well once you follow these steps. The way it works is to check to see if the current row number is an even number, and then format the even numbered rows with a formatting colour/shading of your choice. This method uses the conditional formatting option in Excel that allows you to set the format of a cell or range of cells based on the outcome of a formula. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |