How to Alternate Row Colors in Google Sheets (Zebra Stripes)
Alternating row colors (also called banding or zebra stripes) make long tables much easier to read: your eye can follow a row across the screen without jumping to the one below. Google Sheets has a built-in tool for it, and it takes about ten seconds.
Add alternating colors
- Select your table, including the header row.
- Go to Format → Alternating colors (Alternating colours if your account uses UK English).
- A panel opens on the right. Pick one of the Default styles, or set your own colors under Custom styles.
- Keep Header ticked if the first row is a header, and click Done.
The stripes are part of the range: if you sort the data or insert rows inside it, the pattern stays even. We sorted this same table by Amount, and the rows moved while the stripes stayed in order (see the result in how to sort data).
Header and footer options
- Header gives the first row of the range its own, darker color. Leave it ticked if your data has column names: you'll need it later if you want to convert the range into a table.
- Footer colors the last row differently, which is handy for a totals row.
Change or remove the colors
Click any cell in the range and open Format → Alternating colors again. Pick another style, click the color circles next to Header, Color 1 and Color 2 to choose your own, or click Remove alternating colors at the bottom of the panel.
Every other column, or groups of rows
The built-in tool only stripes rows one by one. For other patterns, use conditional formatting with a custom formula:
| Pattern | Custom formula |
|---|---|
| Every other column | =ISEVEN(COLUMN()) |
| Blocks of 3 rows | =ISEVEN(INT((ROW()-2)/3)) |
| Only rows with data | =AND($A1<>"", ISEVEN(ROW())) |
| Visible rows only (works with filters) | =ISEVEN(SUBTOTAL(3, $A$2:$A2)) |
To apply one: select the range, open Format → Conditional formatting, choose Custom formula is, paste the formula and pick a fill color. Write the formula for the first row of your selection; Sheets adjusts it for the other rows.
Converting the range into a table
Getting an error when you choose Format → Convert to table? See Fix "You cannot convert an alternating color range without a header format into a table" for the cause and two quick fixes.
Frequently asked questions
Why can't I change the fill color of some cells?
If a fill color doesn't seem to apply, check whether the range has alternating colors or a conditional formatting rule: both can hide the color you choose. Change the colors in the Alternating colors panel, or remove it, and try again.
Do the stripes work with filters?
The built-in stripes follow row numbers, so when a filter hides rows you can end up with two rows of the same color next to each other. If that bothers you, remove the alternating colors and use the "visible rows only" formula from the table above. It counts only the rows the filter shows.
How do I stripe only part of a sheet?
Select just that range before opening the panel. You can check or change the covered cells in the Apply to range box at the top of the panel.
Does it work on the mobile app?
Yes. In the Google Sheets app, select the range, tap the A (format) icon, go to the Cell tab and turn on Alternating colors.
Is there a way to keep the header visible too?
Yes, freeze it. See how to freeze rows.