Skip to content

Shade Alternate Rows in Google Sheets

Let’s say that you have some data in Google Sheets.

That’s great, but you want to shade the alternate rows to make each record easier to find and read.

The big question is, how do you add alternating colors across rows in Google Sheets? Is there a quick and easy way to do it?

Keep reading to find out!

How to Add Alternating Colors

To add alternating colors to a range of cells, start by selecting that range.

With the range of cells selected, go to Format Alternating Colors.

The alternating colors panel opens on the right side of your spreadsheet. From here, you can change the color scheme, select a different shading for the header row, and even create your own custom style.

Once you have the colors set up how you want them, simply click on Done.

Also, Google Sheets is smart enough to continue adding alternating colors if you add more data to the list. How amazing is that?

And that is the fastest and easiest way to add alternating colors to your data in Google Sheets.

This Post Has One Comment

  1. I didn’t know that this was an option! It’s so nice to have the alternating grey on long tables of data. Plus is so much less distracting than the colored options!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top