Having alternate colored rows in Google Sheets, or having zebra stripes in Google Sheets helps make the contents of the file easily readable. In absence of alternating colored lines, there are chances that a user (most of the times the reader) is not able to keep track of the correct rows while reading data if the number of columns increase.

This feature of styling alternate rows or having zebra stripes is so common in Microsoft Excel that it has become a part of ‘Quick Styles’ on the ‘Home’ tab of Excel. Earlier, we didn’t have option to color alternate lines in Google Sheets, but it has been added with recent updates.

Zebra lines mean that colour alternative lines of the table. In fact, you can colour alternative column of the table also.

google sheet with zebra stripes

Steps to color alternate rows in Google Sheets

  1. Open a Google Sheet.
  2. Navigate to Format Tab in top menu and then select Alternating colors option.google sheets alternate row colorYou will see a popup open in right side of the sheets as shown below:Google sheets alternate color row
  3. In Apply to range text box, select the range of rows and columns that you want in zebra stripes or alternate row colors. In the example below, I wanted to color from Column A – Row 1 to Column F – Row 8, so we write A1:F8
  4. Next you can decide if you want the Header and Footer included in the color styles. If not, you can just deselect them.
  5.  For our ease, there are some default styles to choose from, but if we don’t like the colors of the default, we can select custom colors for the Header and both the alternate rows:
    custom color rows in google sheets
  6. Click Done to apply the styles or play around until you achieve the desired results.

If you face any hurdles in following the above mentioned steps to have alternate row colors in Google Sheets, feel free to ask in comments below.

We will be glad to help you out.

Enjoy and Stay Techie…

About Parth Kheni

Avatar for Parth KheniA Computer Engineer by profession, Parth Kheni is the Founder of TechMuzz. He is an ardent techie and crazy about gadgets. He feels that the apt use of technology simplifies the life to a great extent and thus wishes to take it at every doorstep.

Pin It on Pinterest

Share This