# How to Color Every Other Row in Microsoft Excel

> To color every other row in Microsoft Excel, first select the desired rows in your worksheet. Next, choose Format As Table from the Home tab on the top menu bar, browse and select an alternating color format, and tap OK to confirm the changes and apply the formatting.

Canonical: https://livedemo.ai/tutorials/how-to-color-every-other-row-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3300ab56e05a00fd6dcb/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, find and select the rows you want to edit.
2. After that, go to the top menu bar and select 'Format As Table' from the available options under the Home tab.
3. Browse the format selections and choose one that perfectly alternates the row color.
4. Subsequently, tap 'OK' to confirm your request.
5. After completing these steps, the color the selected rows will be alternated based on your chosen format.