# Applying Theme to Customize the Appearance

Easily modify the look and feel of your workbook by applying new themes, customizing theme fonts and colors, and removing existing themes.

## Content

You can now easily modify the look & feel of your workbook using the provided themes. Spread themes include options to set the theme color, theme fonts, and theme effects. You can also customize these individual elements and manage overall appearance of the workbook. The tasks that relate to setting the appearance of the workbook include:

* [Applying a New Theme](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-spreadthemeapply#applying-a-new-theme)
* [Customizing the Theme Fonts](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-spreadthemeapply#customizing-the-theme-fonts)
* [Customizing the Theme Colors](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-spreadthemeapply#customizing-the-theme-colors)
* [Removing a Theme](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-spreadthemeapply#removing-a-theme)

Spread themes are shared across all Spread components to provide a uniform look. In case a theme is not specified, default theme settings of are applied to the workbook.

## Applying a New Theme

Use the following code to apply any theme to the workbook to modify the apperance.

```csharp
// To apply a new theme.
var fileName = @"C:\Program Files\Microsoft Office\root\Document Themes 16\Gallery.thmx";
fpSpread1.AsWorkbook().ApplyTheme(fileName);
fpSpread2.AsWorkbook().ApplyTheme(fpSpread1.AsWorkbook().Theme);
```

```vbnet
' To apply a new theme.
Dim fileName As var =  "C:\Program Files\Microsoft Office\root\Document Themes 16\Gallery.thmx"
fpSpread1.AsWorkbook().ApplyTheme(fileName)
fpSpread2.AsWorkbook().ApplyTheme(fpSpread1.AsWorkbook().Theme)
```

Spread provides a number of built-in themes as well. To apply a built-in theme to the workbook, use the **BuiltInThemes** enumeration option from **GrapeCity.Core** namespace as shown below.

```csharp
fpSpread1.AsWorkbook().Theme = Theme.GetTheme(BuiltInThemes.Facet);
```

Using Spread Designer, you can also apply your desired built-in themes. For more information, refer to [Applying and Customizing Themes](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-builtin-themes).

## Customizing the Theme Fonts

Theme fonts contain a heading font and a body text font. You can change both of these fonts to create your own set of theme fonts. Refer to the following code snippet to customize the font scheme of your workbook.

```csharp
// To customize theme fonts.
string fileName = @"C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Fonts\Century Gothic.xml";
fpSpread1.AsWorkbook().Theme.FontScheme.Load(fileName);
fpSpread2.AsWorkbook().Theme.FontScheme.Load(fileName);
```

```vbnet
' To customize theme fonts.
Dim fileName As String =  "C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Fonts\Century Gothic.xml"
fpSpread1.AsWorkbook().Theme.FontScheme.Load(fileName)
fpSpread2.AsWorkbook().Theme.FontScheme.Load(fileName)
```

## Customizing the Theme Colors

Refer to the following code snippet to customize the theme colors of your workbook.

```csharp
// To customize theme colors.
string fileName = @"C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Colors\Yellow Orange.xml";
fpSpread1.AsWorkbook().Theme.ColorScheme.Load(fileName);
fpSpread2.AsWorkbook().Theme.ColorScheme.Load(fileName);
```

```vbnet
' To customize theme colors.
Dim fileName As String =  "C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Colors\Yellow Orange.xml"
fpSpread1.AsWorkbook().Theme.ColorScheme.Load(fileName)
fpSpread2.AsWorkbook().Theme.ColorScheme.Load(fileName)
```

## Removing a Theme

Refer to the following code snippet to remove the currently applied theme from your workbook and change it back to the default theme.

```csharp
//To remove a theme
fpSpread1.AsWorkbook().ApplyTheme("");
fpSpread2.AsWorkbook().ApplyTheme("");
```

```vbnet
' To remove a theme
fpSpread1.AsWorkbook().ApplyTheme("")
fpSpread2.AsWorkbook().ApplyTheme("")
```

## See Also

[Customizing the Sheet Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance)
[Customizing the Dimensions of the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearcontroldims)
[Customizing the Individual Sheet Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearsheet)
[Customizing the Appearance of a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearcell)
[Customizing the Overall Component Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearcontrol)
[Creating and Applying a Style for Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-cellstyle)
[Using Conditional Formatting of Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-interact-condition)
[Customizing the Display of the Pointer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-cntrlcursor)
[Customizing the User Interface Images](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-userimages)
[Using XP Themes with the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearxptheme)
[Customizing the Renderers](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-rendcustom)
[Handling Right-to-Left Layouts](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-rtlsupport)
[Customizing Painting of Parts of the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appear-painting)
[Text Rendering with GDI](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-feattextrender)