To change a table’s color in Excel for Microsoft 365 on Windows, click a cell in the table, open Table Design, and choose a style from Table Styles. For a specific color that is not in the gallery, apply a fill color to selected cells or create a custom table style. The first option is quickest; the others give you more control over the table’s appearance.
What You’ll Need
- A workbook open in Excel. These instructions focus on Excel for Microsoft 365 on Windows.
- A formatted Excel table. If your data is not already a table, select a cell in the data and choose Insert > Table. Check the range and whether your data has headers, then select OK.
- For a custom appearance, decide which parts should change color, such as the header, body rows, or total row. This helps you choose between a built-in style and direct formatting.
Step-by-Step
- Select a cell in the table. Click any cell within the table you want to recolor. Excel should show a contextual Table Design tab on the ribbon. If you see ordinary worksheet tabs only, confirm that the selected cell is inside the table rather than beside it. You do not need to select the entire table to change its style.
- Open the table style options. Select Table Design. In the Table Styles group, you will see style thumbnails. The gallery may show only part of the available styles; select its More button, usually shown as a down arrow with a line above it, to expand the choices. Styles are grouped into Light, Medium, and Dark options.
- Preview and apply a built-in color. Point to a style to preview its colors on the table, then click the style you want. Choose a style with enough contrast between the text, header, and background. If the live preview is unavailable in your version, click a style and use Ctrl+Z on Windows to undo it if you do not like the result. Changing a style does not change the table’s values or formulas.
- Adjust the table’s color pattern. With the table selected, use the checkboxes in Table Design > Table Style Options. Header Row controls the special header formatting, and Total Row adds or removes a specially formatted final row. Banded Rows alternates shading between rows; Banded Columns does the same for columns. First Column and Last Column emphasize those columns. The options available can depend on the style you chose.
- Apply a custom fill to selected cells. If none of the built-in styles provides the exact color you need, select the header or body cells to format. To select the whole table’s cells, click inside it and use Table Design > Select > Entire Table, if that command is available in your ribbon. Then go to Home > Fill Color, select the arrow beside the paint-bucket icon, and choose a color. You can choose More Colors for additional color choices. Select only the relevant cells if you want different colors for the header and body.
- Check text contrast and the result. After applying a fill, inspect the text, header labels, and any totals. If the text becomes hard to read, select those cells and choose a contrasting font color from Home > Font Color. Also check the table at normal zoom and, if it will be printed, in Print Preview. A color that looks clear on screen may print too lightly, especially if the printer uses grayscale.
- Use a custom table style when you need repeatable formatting. On Windows, open the Table Styles gallery using its More button and look for New Table Style. Give the style a name, choose a table element such as the header row or first row stripe, select Format, and set its fill and font options. Repeat for other elements as needed, then select OK. Apply the new style from the gallery. Custom styles are useful when you want consistent formatting that can be reapplied, rather than manually coloring cells each time. The exact dialog or available commands can differ by Excel version.
Excel for Mac has a contextual Table Design tab when a table cell is selected, though the ribbon layout can look different. Look for the table-style gallery and its style options there. You can also select cells and use the fill-color control on the Home tab. Excel for the web supports applying built-in table styles, but its available controls for creating or managing custom styles may differ from the Windows desktop app; use direct fill formatting when the custom-style command is not available.
Common Mistakes
- Formatting a range instead of a table. A colored range may look like a table, but it will not show the contextual Table Design tab or table-style options. Select a cell and check for that tab. If it is not there, create a table with Insert > Table if the data is suitable for one.
- Changing only the header or one row by accident. When applying a custom fill, check what is selected before choosing a color. Selecting one cell changes only that cell. Use the table selection command or carefully select the desired range if you intend to recolor more of the table.
- Expecting a built-in style to use an exact brand color. The gallery offers coordinated preset styles, not every possible color. Use a custom fill for a one-off color or create a custom table style when the formatting needs to be reusable.
- Turning off banded rows and assuming the table is broken. A style may use alternating row fills, and the Banded Rows setting controls that effect. If the rows look too busy or the pattern disappears, check the setting before changing each row by hand.
- Assuming a color change affects the data. Table styles and fill colors change appearance, not values, sorting, filters, or formulas. Still, check that you have not selected the wrong cells before formatting, especially in a large worksheet.
- Forgetting that direct formatting and table styles can interact. A later style change may alter how a table looks and can make manually applied colors inconsistent. For a uniform design you will reuse, prefer a custom table style where available. If you do use direct fills, review the table after changing its style.
Tips
- Choose color for readability first. Use a strong, contrasting header color and keep body fills light enough for dark text. Avoid using several saturated colors in the same table unless they communicate a clear distinction.
- Use banding to make wide tables easier to scan. Alternating row shading can help readers follow data across the worksheet. If the table is narrow or already uses strong column colors, turn off Banded Rows to reduce visual clutter.
- Keep meaning separate from color alone. If a color identifies a status or category, include a text label as well. This makes the information clearer for people who cannot distinguish the colors and for printouts that do not preserve color.
- Reuse styles for consistent reports. A built-in style is a quick choice for a single table. For repeated reports, a named custom style can help keep headers and row stripes consistent within the workbook. Confirm the style is present and looks right in the workbook where you plan to use it.
- Save a copy before making extensive formatting changes. Simple color changes are usually easy to undo, but a copy gives you a fallback if you change multiple tables, styles, or worksheet settings at once.
Troubleshooting
The Table Design tab is missing. Click inside the data again. If the tab still does not appear, the data may be a normal cell range rather than an Excel table. Select a cell in the data and choose Insert > Table, verify the range, indicate whether the first row contains headers, and select OK. If the data is already a table but you are using Excel for the web or Mac, look for the contextual table tab in that version’s ribbon layout.
The chosen style does not change the whole table. Check whether you applied a style or changed a fill color on only selected cells. Reopen Table Design and select another style from the gallery to apply a table-wide preset. If you intended a custom fill, select the exact range first. Also check Header Row, Banded Rows, and related options; these can make a style appear different from its thumbnail.
Some cells keep their old colors. Those cells may have direct fill formatting, or a conditional formatting rule may be controlling their appearance. Select an affected cell and inspect Home > Fill Color. To review conditional formatting, select the affected range and open Home > Conditional Formatting > Manage Rules. In the rules manager, check which rules apply to the selection and adjust or remove a rule only if you are sure it is not needed. Conditional formatting can override the color you expect to see based on cell values.
The custom color is missing from the style gallery. Check that the style was saved in the workbook and that you are looking in the correct gallery section. Custom styles may not be available in the same way across desktop and web versions. If you cannot find the named style in your current version, apply a fill color directly or open the workbook in Excel for Microsoft 365 on Windows and check the custom-style options there.
The text is difficult to read or the color prints poorly. Choose a lighter or darker fill, then adjust font color with Home > Font Color. For printing, check the worksheet in File > Print and consider whether the colors remain distinct in a grayscale printout. You can also use bold text, borders, or labels to preserve the table’s visual structure without relying on color alone.
Frequently Asked Questions
Can I change only the header color?
Select the header cells and use Home > Fill Color to apply a specific color. For a reusable table-wide design, edit or create a custom table style and format its header element, where that option is available.
Can I use my own exact color?
Yes. Select the cells, open the arrow beside Home > Fill Color, and choose More Colors if it appears in your version. You can also define a color in a custom table style on versions that support creating one.
Will changing a table’s color affect formulas or filters?
No. A table style or fill color changes formatting only. It does not rewrite cell values or formulas, and it does not remove the table’s filter controls.
How do I remove a table color?
Open Table Design and choose a plainer style from the gallery, or use the style gallery’s clear or none option if it is shown. For manually colored cells, select them and use Home > Fill Color > No Fill. A style may still add formatting to table headers or stripes, so check the table afterward.
Why does the color change when I sort or add a row?
Table styles format table elements, including banded rows, so their appearance can follow the table when rows are sorted or added. A manually colored cell may not behave like a table-style element. Use a table style or custom style for formatting that should remain consistent as the table changes.
Can I change a table’s color in Excel for the web?
Yes. Select a table cell and use the table design controls to apply an available style. Ribbon features for creating custom styles may differ from Excel for Windows, so use the cell fill-color control for a specific color if the custom-style option is not offered.
Related
- How to Add in Excel Across Different Sheets
- How to Add an Image in Excel: Step-by-Step
- Add a Drop-Down in Excel and Color Its Selected Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filter on Two Columns: A Practical GuideYes. In Google Sheets, create a filter for your data, then apply a condition in each of the…
- How to Delete a Page in Microsoft Word 365: Step by StepTo delete a page in Microsoft Word 365 on Windows, press Ctrl+G, enter \page, press Enter, close the…
- Excel Invoice Bill Format: Build a Useful TemplateAn Excel invoice bill format is a worksheet that records seller and customer details, invoice dates and numbers,…
- Outlook Address Book Cache: How to Clear It SafelyTo clear Outlook’s saved recipient suggestions in classic Outlook for Windows, go to File > Options > Mail…
- Excel Columns Keep Collapsing? Causes and FixesIf Excel columns keep collapsing, they are usually hidden or grouped into an outline—not deleted. On Windows, select…
- Automatic Borders in Excel: How to Apply Them as You TypeTo make borders appear automatically in Excel, select the cells you want to format, then use Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.