Excel Table Colours: Change, Customize, and Fix Them

Errors & fixes · Updated November 18, 2026

Excel table colours come from the table’s style: select a cell in the table, open Table Design, and choose a design in Table Styles. To change the appearance more precisely, adjust the workbook theme, create a custom table style, or apply ordinary cell formatting; these options affect the table in different ways.

What Excel table colours mean

An Excel table is a structured data range with features such as filter buttons, a header row, and automatic expansion when you add data. Its colours are visual formatting, not a special data property. A blue header, alternating pale-blue rows, or a coloured total row usually comes from the selected table style and the table-style options enabled for that table.

Excel’s built-in styles are grouped broadly into Light, Medium, and Dark designs. The names and exact colours can vary with the Office theme and Excel version. Light styles generally use restrained fills and are often suitable for dense data; Medium styles use more prominent headers or banding; Dark styles make stronger use of filled areas. These are broad design categories, not rules about what a colour means.

Colour does not change how Excel sorts, filters, calculates, or interprets values. A green cell is not automatically a warning, and a red cell is not necessarily an error. If colour communicates a status such as overdue or complete, define that meaning clearly and consider adding text or an icon so colour is not the only signal.

Apply or change a built-in table style

In Excel for Microsoft 365 on Windows, click any cell in the table. The contextual Table Design tab appears on the ribbon. In Table Styles, choose a visible style, or open the gallery’s More button to see additional choices. Hovering over a style previews its appearance; selecting one applies it to the table.

If the data is not yet an Excel table, select a cell in the range and choose Home > Format as Table, then pick a style. Check that the selected range is correct and indicate whether the table has headers in the dialog. You can also use Ctrl+T on Windows to open the Create Table dialog. On a Mac, the equivalent shortcut is usually Control+T; if that shortcut is intercepted by macOS or a keyboard setting, use Insert > Table.

To replace the current colours, select a different style in the gallery. You do not need to convert the table back to a normal range. The table remains a table, so its filters, structured references, and automatic range expansion continue to work.

Choose colours that make the data easier to read

The best style is the one that helps readers scan the information without competing with it. A table with dozens of columns often benefits from a light body fill and subtle row banding. A compact summary may suit a stronger header. If the sheet already contains charts, status colours, or other visual emphasis, a neutral table style can prevent the page from becoming visually noisy.

  • For long lists: use gentle banding so readers can follow a row across the screen. Avoid alternating fills with very little contrast.
  • For printed reports: check the style in print preview. Pale fills may print poorly in grayscale, while large dark fills can use substantial toner.
  • For status tracking: reserve bright colours for meaningful exceptions, such as late items, and explain the colour key near the table.
  • For shared workbooks: use familiar, restrained colours and do not rely on subtle differences that may be hard to distinguish on another display.

Also consider the header text. A strong fill needs readable text colour, and small text over a busy pattern is difficult to scan. Excel’s built-in styles coordinate many of these choices, but it is still worth checking the result at the zoom level and screen size readers are likely to use.

How table-style options control the pattern

A style’s appearance depends partly on which table elements are turned on. With a table selected, use the checkboxes in Table Design > Table Style Options. Options include Header Row, Total Row, Banded Rows, First Column, Last Column, and Banded Columns. Not every option is equally useful for every layout.

  • Banded Rows alternates formatting across rows, which can make wide tables easier to follow.
  • Banded Columns alternates formatting down columns. It can help distinguish fields, but may make a busy table harder to read.
  • First Column and Last Column apply emphasis defined by the style to those columns. They do not identify a particular field by its name.
  • Total Row adds a table row for summaries. You can choose a calculation from a cell’s drop-down, such as Sum or Average; the row’s colour is still controlled by formatting.

For example, a sales table with a salesperson in the first column and monthly figures in the remaining columns might benefit from banded rows, but not banded columns. If the last column contains a calculated margin, enabling Last Column may help draw attention to it, provided the style makes the emphasis clear.

Customize theme colours and table colours

Many built-in table styles use the workbook’s theme colours. Changing the theme can therefore alter the palette used by theme-based formatting elsewhere in the workbook as well as the appearance of some table styles. On Windows, open Page Layout > Themes > Colors and choose a different colour set. To define a set, use Customize Colors, give the theme a name, and save it.

This is a workbook-wide design decision, not a command to recolour only one table. Other objects using theme colours, such as shapes or charts, may change too. If you are preparing a workbook for an organisation, use its approved theme palette where available. If only one table needs a distinctive appearance, a custom table style or carefully applied cell formatting is usually a more targeted choice.

On Mac and in Excel for the web, ribbon layouts and available theme controls can differ from the Windows desktop instructions. Select the table and look for the contextual Table or Table Design tab and its style gallery. If a specific theme-customization command is not available in your edition, set up the theme in desktop Excel for Windows or use a style and formatting options available in that version.

Create a custom table style

A custom style is useful when none of the built-in combinations fits a recurring report. In Excel for Microsoft 365 on Windows, select the table, open Table Design > Table Styles, open the gallery’s More button, and choose New Table Style. In the dialog, name the style, select a table element such as Header Row or First Row Stripe, and use Format to set its font, border, or fill. Repeat for other elements as needed, then confirm the dialog and apply the style from the gallery.

Think through the elements before formatting. A header style should remain distinct from body rows, and stripe colours should be light enough to preserve legible text. If you want alternating body rows, format the first and second row stripe elements rather than manually colouring every other row. That lets the table style maintain the pattern as the table grows.

Custom styles are stored with the workbook, so do not assume that a style created in one file will automatically appear in every unrelated workbook. If you need a consistent design across files, save a workbook or template that contains the style and use it as the starting point. Custom-style creation and editing controls may be more limited in Excel for the web or Mac than in Windows desktop Excel.

Table styles, manual fills, and conditional formatting

These three approaches are related but serve different purposes. A table style gives the table a coordinated overall design. A manual fill colours selected cells directly, which is useful for a one-off highlight but can become difficult to maintain. Conditional formatting changes a cell’s appearance when its value meets a rule, such as highlighting dates before today.

Direct formatting can cover or conflict with the colour supplied by a table style. This is a common reason a table appears to ignore a newly selected style: one or more cells may have their own fill or font formatting. Select the affected cells and use Home > Clear > Clear Formats to remove direct formatting, then review the table style. Be aware that clearing formats removes other direct formatting too, not just the fill colour.

Conditional formatting is a good choice for values that need to stand out dynamically. For example, a rule can highlight a due date that has passed; the highlight changes as the date or current day changes. It does not replace the table’s base design, and a conditional-formatting rule can take precedence visually where its conditions apply. Review rules under Home > Conditional Formatting > Manage Rules if a cell’s displayed colour seems inconsistent.

Fix common table-colour problems

  • The style gallery does not appear: click inside the table, not merely beside it. If the range is not a table, create one with Home > Format as Table.
  • Rows are not alternating: select the table and check Table Design > Banded Rows. Also confirm the chosen style visibly uses row banding.
  • The header colour does not change: confirm that Header Row is enabled and that the range has a header row. Check for direct formatting or conditional-formatting rules on the header cells.
  • Some cells keep a different colour: inspect their direct fill formatting and conditional-formatting rules. Reapplying a table style may not remove all cell-level formatting.
  • The colours changed in other parts of the workbook: a theme change can affect other theme-coloured objects. Undo if appropriate, or use a table-specific style instead.

Filters and sorting do not normally remove the table’s style; the formatting follows the table rows as they are rearranged. If a worksheet is protected, some formatting changes may be blocked depending on the protection settings. In that case, the sheet owner may need to change the permissions or update the formatting.

Frequently Asked Questions

How do I change the colour of an Excel table?

Click a cell in the table, open Table Design, and choose a style in Table Styles. For more control, create a custom style or apply a cell fill to selected cells.

Can I use my own colours in an Excel table?

Yes. On Windows desktop Excel, create a custom table style and define fills for elements such as the header and row stripes. You can also apply direct cell formatting, though it is less convenient to maintain as the table changes.

Why are my Excel table colours not alternating?

Check that Banded Rows is enabled in Table Design > Table Style Options and that the chosen style includes visible banding. Direct formatting on cells can also obscure the style.

Do Excel table colours change when I sort or filter?

Usually, no. The table’s formatting remains with the table as its rows are sorted or filtered. A style using banded rows may display the alternating pattern according to the rows’ current order.

Can I change one table’s colours without changing the whole workbook?

Yes. Choose a different table style, create a custom table style, or format that table’s cells directly. Changing the workbook theme is broader and may affect other objects that use theme colours.

Related

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.