Excel Table Styles: Format, Customize & Brand Your Tables

Most people treat Excel table styles like a paint job — something you slap on at the end to make a spreadsheet look less ugly. That thinking produces the generic blue banded tables you've seen on every corporate dashboard since 2014. The style is the communication. It tells your reader whether the data was prepared carefully or thrown together. By the end of this guide, you'll have a consistently styled, professional-looking table and, optionally, a custom style built to your own color palette that you can reuse across workbooks.

One thing to get out of the way first: table styles and regular cell formatting are not the same thing. Cell formatting applies to individual cells and stays put when you remove a table. Table styles are attached to the table structure itself — they control banded rows, the header row, and the total row as a system, not cell by cell. They also interact with the document theme, which is why, if you've updated to Microsoft 365 recently and your tables suddenly look different, that's not a bug. In 2023, Microsoft changed the default Office Theme, swapping Calibri for Aptos and shifting the default color palette. If your tables looked fine in Excel 2019 and look off now, that's the reason. We'll deal with it. For a broader look at how tables work structurally, the guide to working with Excel tables and ranges covers the foundations well.

---

Step 1: Apply an Excel Table Style from the Gallery (Light, Medium, or Dark)

Select any cell inside your data range, go to the Home tab, and click Format as Table. Excel will prompt you to confirm the range and whether your table has headers — check both before clicking OK. Once the table is created, the Table Design tab appears in the ribbon and the Table Styles gallery sits right in the middle.

Hover over any style to preview it live on your table. Click to apply. That's the mechanical part. Here's what most guides skip.

How to Pick the Right Style Tier for Your Context

The gallery gives you three tiers: Light, Medium, and Dark. Choosing between them isn't about personal taste — it's about where the table is going and who's reading it.

• Light styles work well for print reports and internal documents where the table is one element among many. The low contrast doesn't compete with surrounding content.
• Medium styles suit screen-based dashboards where you need clear row separation without going too dark.
• Dark styles are high-contrast and look strong on screen, but they're often a mistake for anything that might get printed — especially in a mixed-environment office where someone's definitely printing it in grayscale.

I used to default to Medium Blue for everything, until a client printed a board report in grayscale and the banded rows turned into muddy gray stripes that made the numbers harder to read, not easier. After that, I stopped picking styles on a monitor alone. Print preview before you commit.

If you're new to Excel tables and want to understand the underlying structure before styling, the Excel for Beginners starter guide is worth reading first.

---

Step 2: Customize Table Style Options and Build a Custom Excel Table Style for Brand Consistency

Once you've applied a style from the gallery, the Table Design tab gives you a row of checkboxes on the left: Header Row, Total Row, Banded Rows, Banded Columns, First Column, Last Column. These are where most people stop customizing. They shouldn't.

Toggle Header Row, Banded Rows, and Total Row

A rule borrowed from a designer I worked under early in my career: if you can't explain why a formatting element is there, it shouldn't be there. Her exact words: "Every element must be defensible." Most people leave Banded Columns checked because it was checked by default. Turn it off. Banded columns create vertical striping that pulls the eye down the table instead of across the row. You're reading left to right — the formatting should support that direction.

Banded Rows, on the other hand, earn their place. They guide the eye across a row of data without requiring gridlines. Keep them. The Total Row checkbox adds a summary row at the bottom with a dropdown for sum, average, count, and other functions. Turn it on if your table needs a footer calculation; leave it off if it doesn't.

Create a Custom Table Style You Can Reuse

Here's the problem with built-in styles: they pull from the document theme, and the document theme is almost never your actual brand palette. To fix this permanently, right-click any style in the gallery and choose Duplicate. This opens the Modify Table Style dialog, where you can set fill colors, font, and borders for each table element separately — header row, first row stripe, second row stripe, and so on.

1. Right-click any style in the Table Styles gallery and select Duplicate.
2. Give the new style a name you'll recognize (e.g., "Brand Report Style").
3. Select Header Row from the element list, then click Format to set fill color, font color, and any border styling.
4. Repeat for First Row Stripe and Second Row Stripe to set your banded row colors.
5. Click OK to save. The style will appear at the top of your gallery under "Custom."

For reports going to a director or above, I set the header row fill to charcoal (#333333) with white text and use a near-white gray (#F2F2F2) for the first row stripe against a white background. The contrast is subtle enough to guide the eye without competing with the numbers. Teal (#2C8C99) gets used sparingly — sometimes as a header accent, never as a banded row color. The goal is preattentive processing: reduce visual friction so the data receives attention, not the stripes.

Custom styles are saved to the workbook, not globally. To reuse them across workbooks, save the file as an .xltx template. Any new workbook built from that template will have the custom style available — the correct workflow for brand consistency across a team where shared dashboards get opened in multiple files every week.

---

Common Mistakes With Excel Table Styles (Including the Remove-Formatting Trap Most Guides Skip)

After years of building executive-facing reports, these are the three issues I see consistently.

Mistake 1: Removing Table Formatting the Wrong Way

If you right-click the table and choose Convert to Range while a style is still active, the table structure disappears — but so does your style, often leaving inconsistent cell-level formatting behind that's annoying to clean up. The correct order: go to Table Design → Table Styles, select None first, then convert to range if needed.

Mistake 2: Ignoring Conditional Formatting Conflicts

Table styles and conditional formatting can coexist, but conditional formatting rules sit on top of table styles and take priority wherever they overlap. If you've applied a custom table style and a conditional formatting rule isn't showing correctly, check the rule order under Home → Conditional Formatting → Manage Rules. The rule at the top wins. Layer them intentionally, not accidentally.

Mistake 3: Using VBA Without Accounting for the Table Object Model

Table formatting applied via Format as Table sits outside the normal cell formatting object model. If you're writing a macro to apply or modify a table style and it's silently failing, that's why — you need to use the ListObject and TableStyle properties rather than standard range formatting methods. Most intermediate users don't discover this until a macro applies everything except the style they expected.

---

Frequently Asked Questions