Question

How to apply existing theme to a worksheeet in excel?

Answer 1

To change the text fonts, colors, or general look of objects in all worksheets of your workbook quickly, try switching to another theme or customizing a theme to meet your needs. If you like a specific theme, you can make it the default for all new workbooks.

To switch to another theme, click Page Layout >Themes, and pick the one you want.


To customize that theme, you can change its colors, fonts, and effects as needed, save them with the current theme, and make it the default theme for all new workbooks if you want.

Change theme colors

Picking a different theme color palette or changing its colors will affect the available colors in the color picker and the colors you've used in your workbook.

Click Page Layout > Colors, and pick the set of colors you want.

The first set of colors is used in the current theme.


To create your own set of colors, clickCustomize Colors.

For each theme color you want to change, click the button next to that color, and pick a color under Theme Colors.



To add your own color, click More Colors, and then pick a color on the Standard tab or enter numbers on the Custom tab.

Tip: In the Sample box, you get a preview of the changes you made.

In the Name box, type a name for the new color set, and click Save.

Tip: You can click Reset before you click Saveif you want to return to the original colors.

To save these new theme colors with the current theme, click Page Layout > Themes >Save Current Theme.