Remove styles

When you work with firesys in Excel, over time a document can sometimes end up with a large number of styles, which can result in unmanageable files or cause Excel to work more slowly.

<imagemap>Datei:EN_Menüband_Excel_Gestaltung_Formatisierung_StyleGuide.jpg|center|1200px desc none </imagemap>

The function

The view of the Remove styles dialog

With the “Remove styles” function you can remove styles that are no used in your Excel document.

A detailed explanation of the individual steps

How to remove superfluous styles:

• In the “*Layout” menu ribbon, in the “Formatting” group, click on the lower half of the “StyleGuide” button and choose “Remove styles”.

• A dialog opens. Note: If there are no unused styles in your document, an information dialog is displayed.

• In the dialog, select the styles that you want to remove...

• either individually and manually from the list of displayed styles.

• or use the “Select visible” function to select all styles that are currently displayed. Note: You can use the search function at any time to filter the styles that are displayed according to your requirements.

• Click “OK” to confirm your selection.

• A final result report shows an overview of the number of styles that were removed

	Good to know
	All styles that you have linked to other styles with the “Configure line types” function are not displayed in the overview list of those styles that are not used.

See also

The StyleGuide in Excel | An overview of the StyleGuide functions
The StyleGuide
Configure row types

Further contents

→ firesys website
→ Customer area
→ YouTube