How to Apply Alternating Colours in Google Sheets for Clean Zebra-Striped Tables

Scanning through extensive spreadsheets filled with dozens of columns and hundreds of rows of numerical data quickly strains the eyes. When every row shares the exact same stark white background, tracing a specific value across the sheet often results in slipping onto adjacent lines and misreading key records. In document formatting and print typography, the standard remedy is zebra striping—alternating between white and light tinted backgrounds across consecutive rows.

While you could theoretically color rows manually or write complex conditional formatting formulas using ISEVEN(ROW()), Google Sheets provides a dedicated, native tool called Alternating colours. This built-in feature styles tables instantly, automatically preserves colour alternation when you insert, delete, or sort rows, and allows customized corporate palette schemes. This guide explains how to format your spreadsheets with alternating colours.

Why Native Alternating Colours Outperforms Manual Shading

Relying on manual cell fill colours creates maintenance headaches whenever your dataset evolves:

• Sorting Resilience: When you sort a table by a particular column, manually coloured rows get scrambled into awkward blocks of identical colours. The native Alternating colours feature remains tied to the display grid, keeping the alternating rhythm intact.
• Row Insertions & Deletions: Adding a new row between existing entries automatically inherits the correct alternating tint without requiring reformatting.
• Distinct Header and Footer Logic: The tool allows independent formatting for column headers and summary/footer rows, preventing summary data from blending into the main dataset.

How to Apply Alternating Colours to a Range

Applying zebra stripes to your spreadsheet takes just a few clicks:

1. Click and drag to highlight the range of cells you want to style (for example, A1:G50). If your dataset will expand over time, you can select full columns such as A:G.
2. From the top menu bar, click Format.
3. Select Alternating colours from the dropdown list.
4. An Alternating colours configuration panel will open on the right side of your browser window.
5. Review the Apply to range field to verify your target cells.
6. In the Default styles section, click on one of the pre-designed palettes (such as subtle grey, soft blue, teal, or mint green).
7. Observe how the table updates instantly on your screen, then click Done.

Customising Header, Footer, and Alternating Palette Tones

If your organisation follows specific branding guidelines or you prefer custom colour contrast, you can tailor every element:

1. Open the Alternating colours sidebar (via Format > Alternating colours).
2. Under Options, ensure the Header checkbox is selected if row 1 contains column labels. Check Footer if your table ends with total or average calculations.
3. Scroll down to the Custom styles section:
   • Header: Click the paint bucket to choose a bold accent tone for the top row.
   • Colour 1: Select the primary row tone (typically pure white #ffffff).
   • Colour 2: Select the alternating tint (a soft pastel shade like very light grey or pale blue).
   • Footer: Assign a distinct tone to highlight final summary metrics.
4. Click Done to save your customized theme.

Removing Alternating Colours from a Table

If you need to export clean unformatted text or transition your data into a presentation layout, removing the formatting takes seconds:

1. Click any cell inside the styled range.
2. Open Format > Alternating colours.
3. At the bottom of the right-hand panel, click the Remove alternating colours button.

The cells will instantly revert to standard unstyled gridlines without erasing your formulas, text alignment, or cell data.