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:
Select the range you want to apply alternating colors to.
Open the Format menu and select the Alternating Colors option near the bottom
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
You can also individually set colors for a custom style under custom styles
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.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.