Cell Styles in Calc

    From The Document Foundation Wiki
    This page is a translated version of the page Videos/Cell Styles in Calc and the translation is 8% complete.
    Other languages:
    "Hierarchical" Styles in Sidebar

    Foreword

    The video "Zellvorlagen in Calc - LibreOffice" shows how to create and apply "Cell Styles in Calc" and links to this page here, which provides further information and details.

    Link to the Video

    Link to the Video (in German [DE]):

    Create and apply cell styles

    Hierarchy of Cell styles

    The Cell style "Default" is the source of all other Cell styles.

    The Styles located one level below the "Default" style in the hierarchy are all direct derived from it.

    Select Cell styles Calc - Sidebar Styles Icon Cell styles.png in the sidebar ( Ctrl + F5 ) and select "Hierarchical" at the bottom to see the hierarchy.

    Cell styles with different backgrounds

    "New…" menu

    The best way to change the background of cells is to use Cell styles.

    To do this, create a new Cell style for each color.

    Right-click on the Cell style "Default" and select New….

    In the Cell Style dialog, enter a name for the new Cell style in the "Organiser" tab.

    In the "Background" tab, select the Colour button and choose the desired color, then click OK.

    Now select the cells that should get a different color.

    Double click on the new Cell style and you are done.

    If it was the wrong cells, select them again and double-click on the "Default" Cell style.

    Cell styles with different cell border colors

    The best way to change the border of cells is to use Cell styles.

    Right-click on the "Default" Cell style and select New….

    In the Cell Style dialog, enter a name for the new Cell style in the "Organiser" tab.

    In the Border tab, select the Line Style, -Color and -Width, then click the "Set for All Four Borders" icon at the top and klick OK.

    Now select the cells that you want to have a different border color.

    Dobbeltklik på den nye celletypografi og du har klaret det.

    Hvis det var de forkerte celler, markerer du den igen og dobbeltklikker på celletypografien "Standard".

    Cell Styles with multiple changed attributes

    several Font Effects
    several changed attributes
    Diverse Cell Styles

    You can also create Cell Styles with multiple changed attributes.

    Cell Styles with different Font Effects

    Right-click on the "Default" Cell style and choose New....

    In the Cell Style dialog, enter a name for the new Cell Style in the "Organiser" tab.

    In the "Font Effects" tab, select the "Font colour" and choose the color you want, then click OK.

    In the "Font" tab, select the Size.

    Now click OK.

    Now select the cells that should be changed.

    Double-click on the new Cell Style and you're done.

    If it was the wrong cells, select them again and double-click on the "Default" Cell style.

    Cell Styles with changed background and border color

    Højreklik på celletypografien on the "Standard" og vælg Ny....

    In the Cell Style dialog, enter a name for the new Cell Style in the "Organiser" tab.

    In the "Background" tab, select the Colour button and choose the color you want, then click OK.

    På fanebladet "Kanter" vælger du linjetypografi, -farve og -bredde og klikker så på ikonet "Indstil for alle fire kanter" øverst.

    Now click OK.

    Now select the cells that should be changed.

    Double-click on the new Cell Style and you're done.

    Hvis det var de forkerte celler, markerer du dem igen og dobbeltklikker på celletypografien "Standard".

    Cell styles with further modified properties

    You can, of course, design your cell styles to suit your needs, i.e. you can change all properties, such as font type and -size.

    Or you can create cell styles, e.g. for currency or for time.

    An example file with various cell styles can be found at Work files.

    In the sidebar, look at the sorting at the bottom for format styles.

    Note pin.svg

    Note:
    The "Default" cell style should remain untouched. Changes to it will affect the cell styles below it in the hierarchy.

    Note pin.svg

    Note:
    If you need the new cell styles more often, you should create a document template with the created cell styles.

    Transfer a cell style to another document

    Open a document-A that contains the cell style you want to transfer.

    And open the document-B to which you want to transfer.

    In document-A, copy a cell ( Ctrl + C ) that contains the cell style you want to copy.

    Now insert the empty cell in a suitable place ( Ctrl + V ) to document-B.

    You have now transferred the cell formatting.

    Apply the cell template.

    Select the desired cells and double-click the new cell style.

    Further Informations

    Work files

    Related topics

    Autoformater typografier in Calc - LO53

    Autoformater Tabeltypografier Calc+Writer - LO70

    Documentation / Manuals

    Here you will find the Documentation / Manuals:

    Any questions?

    For questions on this topic go to:

    Get Involved

    Join us today and help us to make it even better!

    LibreOffice is Free Software and is made available free of charge.

    Your donation, which is purely optional, supports our worldwide community.

    If you like the software, please consider a Donation.