How to Format Alternating Row Colors in Excel 2010

Improving the display of your spreadsheet is important when you are trying to improve the readability for a human audience. Most people have a hard time reading and understanding large sets of a numbers in a traditional spreadsheet layout, so you need to take action to present the material in a way that is more appealing. One way to accomplish this is through the use of alternating row colors. By adding a fill color to your rows you are adding a way for your readers to be able to track data sets through that entire row, without accidentally dropping their eyes to a different row. You can learn how to format alternating rows colors in Microsoft Excel 2010 using the procedure outlined further in this article.

 

Banding Rows in Excel 2010

 

The act of formatting alternating rows with different fill colors is also referred to as “banding.” If you have ever seen an Excel spreadsheet with this effect, then you know how useful it can be in visually organizing your data. However, you might have tried to do it yourself manually, but found that the entire process can be somewhat tedious. Fortunately there is a simple way to automate it that you will find beneficial.

 

Step 1: Open the Excel 2010 spreadsheet to which you want to add your alternating row colors.

Step 2: Click the Home tab at the top of the window.

Step 3: Click the row heading for the first row to select the entire row, then click the Fill Color button in the font section of the ribbon and choose your first row color.

fill the first row

 

Step 4: Click the row heading for the row underneath that row to select the entire row, click the Fill Color button again, then choose the alternating color.

fill second row

 

Step 5: Highlight the two rows that you just filled.

Step 6: Click the Format Painter button in the Clipboard section of the ribbon.

use the format painter tool

 

Step 7: Use your mouse to select the rest of the rows to which you want to apply the alternating row colors.

select the rows where you want alternating colors

 

Step 8: Release the mouse button to fill your selected rows with the alternating row colors.

how to format alternating row colors in excel 2010

 

Note that, after you use the Format Painter tool, the rows are not tied to one another in any way. Therefore you can feel free to manually adjust any rows colors that you wish and it will not affect the appearance of the rest of the row colors.