Excel Table Banded Rows Not Working? Fix It in Excel

If banded rows are not showing, select a cell in the table, open Table Design, turn on Banded Rows, and choose a table style that visibly formats alternating rows. If the option is already on, direct cell formatting or conditional formatting may be covering the style.

How Excel table banding works

Banded rows are part of an Excel table’s style. Excel applies alternating formatting to the table’s data rows, making it easier to follow a record across the screen. The stripes are not a separate worksheet feature: they depend on the range being a real Excel table and on its selected style defining visible row bands.

In Excel for Microsoft 365 on Windows, click a cell in the table to show the contextual Table Design tab. In Table Style Options, select Banded Rows. The option enables row banding, but it cannot make an unstriped style look striped. Choose a built-in table style with a clear alternating fill if the current style is very subtle or has no obvious contrast.

Header Row, Total Row, First Column, Last Column, and Banded Columns are separate style options. They can change other parts of the table, but they do not replace Banded Rows. A header’s different color, for example, does not mean the data rows are banded.

First check that the range is an Excel table

Ordinary worksheet cells can be colored to resemble a table, but they do not have table-style behavior. Click inside the range and look for the Table Design tab. If it does not appear, the selected range may not be a table, or the selection may be outside the table.

A real table usually has filter arrows in its header cells, although those arrows can be turned off. You can also click in the suspected range and check whether Table Design appears. If you need to convert a range, select the data and use Insert > Table. Confirm the proposed range and indicate whether the first row contains headers. Excel will create a table and apply a style; then you can select Banded Rows on Table Design.

Make sure the range covers all the records you expect. A blank row or column can cause Excel to identify a smaller range than intended when creating a table. Rows outside the table will not receive the table’s banding, even if they sit directly below it and have similar data.

Restore banding with a quick checklist

Work through these checks in order. They distinguish a disabled option from a style or formatting conflict:

Click a data cell inside the table, not a nearby worksheet cell.
Open Table Design and confirm Banded Rows is selected under Table Style Options.
Open the Table Styles gallery and choose a built-in style with clearly different alternating row fills.
Look for cells that still have a manually applied fill or other formatting.
Check whether conditional formatting applies a fill to the same cells.
Check whether the rows that appear unbanded are actually outside the table or hidden by a filter.

After changing the style or option, inspect several consecutive data rows. If some rows change and others do not, the issue is more likely a formatting override or a boundary problem than the Banded Rows setting itself.

Choose a style with visible stripes

Table styles vary in contrast. Some use a light tint that is difficult to notice on a bright display or when printed; others emphasize the header while keeping the data rows nearly uniform. The Banded Rows checkbox can be on even when the selected style’s stripe colors are subtle. Try a noticeably different built-in style from Table Design > Table Styles before diagnosing a deeper fault.

For a custom appearance, use the Table Styles gallery to create or modify a table style in desktop Excel. A custom style can define the formatting for First Row Stripe and Second Row Stripe, which together create the alternating pattern. Keep the two fills distinct enough to read, but avoid colors that reduce the contrast of text. If the custom style is applied but the bands remain hard to see, revisit the stripe definitions and verify Banded Rows is enabled.

Styles are useful because they keep a consistent appearance as the table grows. When you add a row within or directly below a table, Excel normally extends the table and its style to that row. If a pasted row brings its own formatting, however, the result may not match the surrounding stripes. Check that the table expanded and that the pasted formatting did not override the style.

Check manual formatting and conditional formatting

Cell-level formatting can take precedence over a table style. For instance, if someone selected a few rows and used Home > Fill Color to apply a white fill, those cells may stay white even though the table’s stripes are enabled. A border, font color, or other manually applied format can also make the style appear inconsistent.

To test for a manual override, select one affected cell and compare it with a neighboring cell. You can reapply the table style, or remove formatting from only the affected cells with Home > Clear > Clear Formats. Use Clear Formats carefully: it can remove more than the fill, including font, borders, and number formatting. If those cells contain important formats such as dates or currency, note them first or use a narrower correction instead of clearing everything.

Conditional formatting is another common cause. A rule that colors every other row, highlights values, or applies a fill to a large range can make the table style difficult to see. Open Home > Conditional Formatting > Manage Rules and inspect the rules that apply to the current selection or worksheet. Adjust or remove only the rule responsible for the conflict; deleting unrelated rules can remove useful alerts or analysis. Conditional formatting and table styles serve different purposes, so decide which one should control the fill rather than layering competing colors.

Understand filters, hidden rows, and table boundaries

Filtering hides records; it does not turn the remaining cells into a different table. Because the stripe pattern belongs to table rows, filtered or manually hidden rows can make the visible sequence look as though it skips a band. Clear the filter temporarily and inspect consecutive underlying rows before concluding that banding has stopped. A filter changes which records are displayed, not the table’s Banded Rows setting.

Also verify that every row you are checking belongs to the table. A blank line inserted below the last record, or data pasted beyond the table boundary, may look like part of the same list but remain ordinary cells. Click that row and see whether Table Design appears. If the table did not expand, resize it from Table Design or add the row as part of the table, then confirm that the style extends to it.

Blank rows inside a table are still table rows and can participate in the stripe pattern. By contrast, a blank row outside the table does not become banded simply because it separates table records from nearby worksheet content.

Table styles versus conditional-formatting stripes

Use a table style when the data is a structured list with headers and you want built-in sorting, filtering, and a consistent appearance as the list grows. Its banding is managed through Table Design and the table’s style options. This is usually the simplest choice for a normal Excel data table.

Conditional formatting can create alternating colors on an ordinary range, or apply special colors based on values, but it is a separate mechanism. It can be useful when you need a rule-driven appearance that a table style does not provide. However, rules can overlap, apply to the wrong range, or conflict visually with a table style. If you only want the standard alternating table rows, prefer the table style and remove conflicting conditional formats rather than maintaining two stripe systems.

On Excel for Mac, select a cell in the table and use the contextual table-design controls; the tab name or ribbon layout can differ slightly by release. Excel for the web also exposes table formatting controls when a table is selected, though some desktop style-editing options may not be available there. The core diagnostic is the same: confirm it is a table, enable row banding, select a visibly banded style, and look for overrides.

Frequently Asked Questions

Why is Banded Rows checked but the rows still look the same?
A checked option does not guarantee strong visual contrast. The selected style may use subtle stripe colors, or manual formatting or conditional formatting may cover them. Try a clearly striped built-in style, then inspect any cells that remain different.

Does Banded Rows work on a normal cell range?
No. Banded Rows is a table-style option, so the range must be an Excel table. Use Insert > Table to convert a suitable data range, then select a style and enable the option.

Will filtering turn off the row stripes?
No. Filtering hides records rather than disabling the table style. The remaining visible rows may appear to skip a stripe because hidden records are still part of the table’s row sequence. Clear the filter briefly to check the full pattern.

Can I keep banded rows but use my own colors?
Yes. Choose or define a table style with the stripe colors you want, and leave Banded Rows enabled. Avoid applying a conflicting manual fill or conditional-formatting rule to the same cells if you want the style to remain consistent.

Why are new rows not banded when I add data?
The row may be outside the table, or pasted formatting may have overridden the table style. Check whether clicking the row shows Table Design and whether the table range includes it. Add or resize the table as needed, then check the row’s formatting.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.