Remove styles: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(7 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
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.  
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 Excel Gestaltung Formatvorlagen-entfernen.jpg|center|1200px
 
rect 0 70 69 162 [[Overview_of_the_dashboard]]
[[Datei:EN_Menüband_Excel_Gestaltung_Formatisierung_StyleGuide.jpg|center|1200px]]
rect 71 69 175 162 [[The_basic_functions_of_firesys]]
rect 180 69 247 162 [[The_StyleGuide_in_Excel]]
rect 251 70 406 163 [[Design_texts_in_Excel]]
rect 400 70 468 162 [[Design_texts_in_Excel#Highlighting]]
rect 471 68 562 161 [[Design_texts_in_Excel#Conditional_formatting]]
rect 566 69 645 162 [[Excel-areas#Print_area]]
rect 648 70 795 89 [[Excel-areas#Name_manager]]
rect 647 93 796 113 [[Excel-areas#X.2FY_ranges]]
rect 647 115 796 136 [[Excel-areas#Empty_areas|]]
rect 802 70 964 159 [[Formulas]]
rect 969 71 1093 162 [[Views_and_comments_in_Excel#View]]
rect 1105 72 1363 161 [[Views_and_comments_in_Excel#Comments_in_Excel]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
desc none
</imagemap>




== The function ==
== The function ==
[[Datei:EN Excel Gestaltung Formatvorlagen-entfernent.jpg|mini|upright=1.5|The view of the Remove styles dialog]]
[[Datei:EN Excel Gestaltung Formatvorlagen-entfernent.jpg|mini|upright=1.4|The view of the Remove styles dialog]]


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




{{Vorlage:Video-Formatvorlagen_entfernen-English}}
{{Vorlage:Video-Formatvorlagen_entfernen_Links-English}}




{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen =  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.
|Gutzuwissen =  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.
Zeile 38: Zeile 23:
== See also ==
== See also ==


[[Datei:Navigation_hoch.svg|link=]]  [[The_StyleGuide_in_Excel|An overview of the StyleGuide functions]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[The_StyleGuide_in_Excel|The StyleGuide in Excel | An overview of the StyleGuide functions]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_StyleGuide|The StyleGuide]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_StyleGuide|The StyleGuide]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Configure_row_types|Configure line types with firesys]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Configure_row_types|Configure row types]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-gestalten-StyleGuide]]
[[Kategorie:English-Excel Dokument-gestalten-StyleGuide]]

Aktuelle Version vom 19. November 2021, 12:07 Uhr

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.


EN Menüband Excel Gestaltung Formatisierung StyleGuide.jpg


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



Glühbirne neu.png
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

Navigation hoch.svg The StyleGuide in Excel | An overview of the StyleGuide functions
Navigation rechts.svg The StyleGuide
Navigation rechts.svg Configure row types

Further contents

firesys website
Customer area
YouTube