How To Alternate Colors In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to alternate colors in Google Sheets.

How To Alternate Colors In Google Sheets

Alternating colors in Google Sheets rows can help make data easier to read, especially when your data has many columns to scan across.

Manually formatting rows in alternating colors is time consuming and hard to update if you need to insert or delete rows, but fortunately Google Sheets has a built-in feature to alternate color rows for you.

The feature is quick and easy to use, and automatically recalculates the row colors if you insert or delete rows

Using Alternating Colors Formating

The alternating colors formatting option comes with a number of color presets, or you can set custom colors to get the exact look you want

Follow these steps to add alternating colors to your spreadsheet in just a few clicks:

Step 1

Select the range you want to apply alternating colors to.

Step 2

Open the Format menu and select the Alternating Colors option near the bottom

Step 3

In the sidebar that opens, uncheck the Header checkbox to format the range as alternating colors, then select a style from the list of default styles

Step 4

You can also individually set colors for a custom style under custom styles

Step 5

When you’re happy with the colors, click Done. Your range will now be formatted with alternating colors

Note that if you insert new rows or columns into the middle of the formatted range, Google Sheets will automatically apply the alternating row colors to the inserted rows/columns


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to alternate colors in Google Sheets. Want more? Check out all the Google Sheets Tutorials.