In Excel: use Format as Table and enable Banded Rows, or create a conditional formatting rule with =MOD(ROW(),2)=0.
On this page7
Choose Format as Table for dynamic data.
Use Banded Rows from Table Design.
For a plain range, add a formula-based conditional formatting rule.
Pick a subtle fill so text remains readable.
What this does
Alternating row color improves scanning by shading every other row. Format as Table is easiest because banding expands with the table. Conditional formatting gives more control and can shade based on visible row numbers, groups or custom logic. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “highlight every other row in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected rows change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Select A1:F500, choose Home ▸ Format as Table and keep Banded Rows on. For a normal range, select A2:F500, add a conditional formatting formula =MOD(ROW(),2)=0 and choose a light fill. Row banding is small, but it materially improves readability for wide tables and repeated review work. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Treat “highlight every other row in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
Common mistakes
- Manually coloring rows, then breaking the pattern after sorting.
- Using colors with poor contrast.
- Applying the rule to only one column.
- Forgetting that inserted rows need the rule range to include them.
Frequently asked questions
What formula shades every other row?
=MOD(ROW(),2)=0 shades even rows.
Will banded rows survive sorting?
Yes when done with a table or conditional formatting.
Can I shade by groups instead?
Yes, but use a helper formula based on group changes.
Other ways people ask this
People reach this page typing “highlight every other row in excel”, “how do i highlight every other row in excel”, “how do you highlight every other row in excel” and “how to highlight alternating rows in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “highlight every other row in excel”, “how do i highlight every other row in excel”, “how do you highlight every other row in excel” all point at the one operation explained on this page, which is why they all lead here.