Cell Styles in Calc

    From The Document Foundation Wiki
    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]):

    Zellvorlagen in Calc - LibreOffice

    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.

    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 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

    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 "Background" tab, select the Colour button and choose the color you want, then click OK.

    In the "Borders" tab, select the Line Style, -Colour and -Width, then click the "Set for all four borders" icon at the top.

    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 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

    "Zellvorlagen in Calc - LO72.ods"

    Related topics

    AutoFormat Styles in Calc - LO53

    AutoFormat Table Styles Calc+Writer - LO70

    Faq/Calc/142 - Conditional Formatting

    Documentation / Manuals

    Here you will find the Documentation / Manuals:

    Documentation / Manuals

    Any questions?

    For questions on this topic go to:

    Ask.LibreOffice

    Get Involved

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

    Get Involved

    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.