In Excel, “table themes” usually means the built-in table styles that control a table’s colors, borders, and visual emphasis. To apply one in Microsoft Excel for Microsoft 365 on Windows, click inside the table, open the Table Design tab, and choose a style from Table Styles; the tab also has options for banded rows, a header, and a total row.
What Excel table themes mean
Excel’s interface calls these designs table styles, rather than table themes. A style is a coordinated set of formatting for an Excel table: it can give the header a strong fill, add alternating row shading, distinguish the total row, or emphasize the first or last column. The choices appear in the Table Styles gallery, commonly organized into Light, Medium, and Dark groups.
These styles apply to actual Excel tables, not just any rectangular range of cells. To make a range a table, select a cell in the data and use Insert > Table, or press Ctrl+T on Windows. Confirm the range and whether it has headers. Once the table exists, selecting one of its cells reveals the contextual Table Design tab. A formatted range that has not been converted to a table will not show the same table-style controls.
Table appearance is only one part of what makes a table useful. Tables also provide filter buttons, expand when data is added next to them, and support structured references in formulas. Applying a style changes the presentation; it does not, by itself, change values, sort the records, or alter the table’s calculations.
Table styles versus workbook themes
The words are easy to confuse because Excel also has workbook themes. A workbook theme is a broader set of design choices, including theme colors and fonts, that can affect charts, shapes, and other formatted objects. On Windows, workbook themes are available from Page Layout > Themes. A table style is the particular design applied to a table from the Table Design tab.
Some built-in table styles use theme colors. Changing the workbook theme can therefore change the colors used by some styles while leaving the selected table style in place. Other styles are more neutral and may look less different after a theme change. A theme change is not the same as selecting a different table style, and it can affect other objects in the workbook as well. If only one table needs a new look, select a different table style rather than changing the entire workbook theme.
Nor is a table style the same thing as a cell style. Cell styles are available from Home > Cell Styles and can be applied to individual cells or ranges. Table styles are designed around table elements and can automatically format alternating rows or special columns as the table grows.
How to apply or change a table style
- Click any cell inside the table. If the data is not yet a table, select it and choose Insert > Table, then confirm the range and header setting.
- Open Table Design on the ribbon. This contextual tab appears when a table is selected.
- In Table Styles, select a visible style, or open the gallery’s More control to see additional choices. Pointing at a style generally previews its appearance before you commit to it.
- Use the checkboxes in Table Style Options to turn features such as Banded Rows or First Column on or off. The choices available depend on the table and the ribbon layout.
Choosing a different style does not replace the table’s data or remove its filters. It changes the table’s style assignment. If you cannot see Table Design, check that the selected cell is inside a real table; selecting a nearby cell outside its boundaries will not activate the contextual tab. On Excel for Mac, select the table and use the contextual Table or Table Design tab, depending on the version and ribbon layout. Excel for the web also offers table styling, but its ribbon and available customization controls may differ from desktop Excel.
What the style options control
The style gallery provides the overall design, while Table Style Options decide which table features are displayed or emphasized. They are useful when a style looks nearly right but the visual structure needs adjustment.
- Header Row displays and formats the table’s column headings. Headers help identify fields and are used by table filters and structured references.
- Banded Rows applies alternating shading to rows, making it easier to track across wide datasets. Banded Columns does the same by column where the style supports it.
- First Column and Last Column emphasize the outside columns, often with stronger text or formatting. They do not freeze those columns on screen.
- Total Row adds a row for summaries. Its cells can offer calculations such as Sum, Average, or Count through a drop-down menu. Excel uses the SUBTOTAL function for many of these table totals so filtered records can be handled appropriately.
- Filter Button controls the drop-down filter arrows in the header. Hiding the arrows does not convert the table back into a normal range.
Options can interact with the chosen design. For example, a style may include clear alternating fills, but the banding will not show if Banded Rows is turned off. Likewise, a style can be applied while the First Column option is off, so its first field receives no special emphasis. These settings affect appearance and usability, not the underlying values.
Choosing a style that fits the data
Choose a style for readability first, then consider how it will look when printed or viewed on a screen. A highly saturated fill may work for a small status table but make a long inventory difficult to scan. Alternating light shading is often useful for wide tables because readers can follow a record across several fields. If the sheet already contains colored charts or conditional formatting, a restrained table style can prevent competing visual signals.
- For a long list of transactions, try a light style with Banded Rows enabled.
- For a compact summary, a medium or dark style can make the header and totals stand out, but check that the text remains easy to read.
- For a table with a key identifier in its first field, turn on First Column if the selected style makes that distinction clear.
- For a report that will be printed in grayscale, preview it in print view; color differences that look distinct on screen may become hard to distinguish on paper.
There is no special table style required for formulas, filters, or sorting. A style is a presentation choice, so choose one that supports the way readers use the information rather than assuming that a darker or more elaborate design adds functionality.
Customizing a table style
If the built-in choices do not match a workbook’s design, desktop Excel for Windows can create a custom table style. Open the Table Styles gallery from Table Design and choose New Table Style if that command is available. In the dialog, name the style and choose a table element to format. Depending on the element, you can specify formatting such as a fill, font, or border. For example, you might set a dark header fill and a subtle fill for alternating row stripes, then confirm the changes.
A custom style is useful when several tables in the same workbook should follow consistent colors or borders. It is more precise than applying separate cell formatting to every table, especially if rows are added later. However, the dialog has more options than many users need. For a one-off table, a built-in style plus the Table Style Options checkboxes is usually quicker. Custom-style commands and their exact availability can vary across Excel editions and platforms, so do not assume the Windows dialog will look identical on Mac or in the web app.
Custom table styles belong to the workbook context; if a design must be reused elsewhere, check that it is available after moving or copying the relevant content. Saving a workbook as a template can be a practical way to reuse a workbook’s design and structure. Always inspect the destination workbook after copying a sheet or table, particularly if the styling is important to a published report.
Why table colors or banding may not appear
A table can have a selected style yet still look different from its gallery preview. Start by checking whether the relevant Table Style Options are enabled. If alternating stripes are missing, turn on Banded Rows. If the heading does not look distinct, confirm that Header Row is enabled and that the range’s header was identified correctly when the table was created.
Direct formatting applied to individual cells can also make a table look inconsistent with its style. A manually applied fill, font, or border may visually obscure some of the style’s formatting. Select the affected cells and review the formatting, or reapply the table style and compare the result. Be cautious: clearing formatting can remove intentional number formats or other cell-level choices, so check a small area before making broad changes.
Conditional formatting is another possible source of unexpected colors. Its rules can change cell appearance according to values, independently of the table style. Review Home > Conditional Formatting > Manage Rules if only certain values or rows show different colors. Also check whether a workbook theme was changed, particularly if colors shifted across several tables, charts, or shapes at once.
Finally, confirm that the data is still an Excel table. If someone chose Table Design > Convert to Range, the data remains on the sheet, but table-specific styling and controls no longer behave as they did. A standard cell fill can imitate a table style, but it will not automatically provide table behavior or expand its design to new records.
Table styles and other formatting tools
Table styles are not a replacement for conditional formatting. Use a table style for consistent structure, such as a distinctive header and alternating row bands. Use conditional formatting when a cell’s appearance should depend on its value—for example, highlighting overdue dates or flagging quantities below a threshold. The two can be used together, but check for overlapping colors if the result becomes hard to read.
They also differ from sorting and filtering. The Filter Button option controls whether header arrows are visible; it does not specify which records should be shown. Use the arrows to filter or sort the table’s data. Similarly, turning on Total Row adds a place for a summary but does not make a style calculate every metric automatically: select a calculation from the total cell’s menu or enter an appropriate formula.
If you only want to color a few cells, direct formatting from the Home tab may be simpler than converting the data to a table. But for a growing list that needs consistent headings, filters, and row banding, an actual table is usually the more useful choice.
Frequently Asked Questions
Are Excel table themes and table styles the same thing?
People often use “table theme” informally, but Excel calls the designs in the Table Design gallery table styles. Workbook themes are broader and can affect colors and fonts across several kinds of objects.
How do I remove a table style without deleting the table?
Select the table, open Table Design, and choose the gallery option for clearing the table style, if available in your Excel version. The table remains a table, so its data and table features are not deleted. If the cells still have colors, check for direct formatting or conditional formatting.
Can I change a table style’s colors?
You can choose another built-in style, adjust the workbook theme colors, or create a custom table style where the feature is available. Changing the workbook theme may also affect other workbook objects, so a custom style is more targeted when only one table needs a specific design.
Why are alternating table rows not shaded?
Check that the range is an Excel table, then select it and turn on Banded Rows under Table Design. A style with very subtle stripes, direct cell fills, or conditional formatting can also make banding difficult to see.
Do table styles change my data or formulas?
No. Applying a style changes the table’s appearance. Options such as Total Row can add a summary row, but the style itself does not rewrite the table’s existing records or formulas.
Related
- Excel Data Validation Date Picker: Setup and Options
- Excel Data Validation for Dates: Rules and Examples
- Data Validation Checks in Excel: Rules and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Small Labels in Microsoft Word: How to Create ThemTo create small labels in Microsoft Word, open Mailings > Labels, choose Options to select the label sheet’s…
- Excel File Merge Online Free: Safe Ways to Combine WorkbooksYes, you can merge Excel files online for free, but the best method depends on what you mean…
- How to Add a Header to Each Page in Microsoft WordTo add a header to every page in Word, choose Insert > Header, select a layout, type your…
- Excel Online Page Break Preview: Limits and WorkaroundsExcel for the web does not include the desktop Excel Page Break Preview view, so you cannot use…
- Clean Excel Sheet: Remove Gridlines and BordersTo clean up an Excel sheet with no cell lines, open the worksheet and choose View > Show…
- Add an Image Watermark in Word: A Clear Step-by-Step GuideTo add an image watermark in Microsoft Word for Microsoft 365 on Windows, open the Design tab, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.