How to Add Alternating Colors for Rows in Google Sheets

Google Sheets make the alternating color for rows much easier than the Microsoft Excel. Please see below for details:

Step 1: Select the data range you want to have alternating colors;

Step 2: Click the "Format" tab from the ribbon;

Step 3: Click the "Alternating colors" from the drop-down list;

Step 4: Select a style from the style panel on the right of the spreadsheet. Please note the header and footer will be different if you check the box;

Step 5: You can also custom the style and change the color in the panel on the right.

Step 6: If you want to remove the alternating colors, you can repeat the above steps and on the right panel, click "Removing alternative colors" at the end of the drop-down list.

Leave a Reply