Chat with us, powered by LiveChat

Excel Color Scheme

How to Create and Apply Color Schemes in Excel

You can quickly customize the look of your spreadsheet by using color schemes. A color scheme is a set of eight coordinating colors used in formatting text and objects in the worksheet.

Apply a Color Scheme

  1. Click the Page Layout tab.
  2. Click the Colors button in the Themes group.
    Apply a Color Theme

    Each color scheme listed here shows a small preview of the colors in that set. Any text, shapes, or SmartArt graphics using theme colors will be affected by a change here.

    Hover over a palette to see a preview of what it will look like applied to your spreadsheet.

  3. Select a color palette.

The worksheet’s colors are updated. Anything set to use theme colors, such as heading text or shapes, will be updated. This palette will now be available anywhere you’re selecting color formats in your spreadsheet.

Create a Custom Color Scheme

You can create your own color set to give your document a fresh, unique look or comply with your organization’s brand standards.

  1. Click the Page Layout tab.
  2. Click the Colors button in the Themes group.
  3. Select Create a Custom Color Scheme button.
    Create a Custom Color Scheme

    The Create New Theme Colors dialog box appears where you can modify any of the 12 coordinating theme colors.

    You can switch the colors with another from the current theme or a variant of one of those colors.

    If you’d prefer to create a new color set entirely, rather than shuffling existing theme colors around, you can.

  4. Set the theme colors.
  5. Enter a name for your color palette.
  6. Click Save.
    Create a Custom Color Scheme

The new color set is saved and automatically applied. You can click the Colors button again to see your custom color scheme in the menu. The custom color scheme is available in all spreadsheets as well as other Office applications.