Site icon ExcelNotes

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.

Exit mobile version