Cell Styles in Calc

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
Deutsch • ‎English • ‎dansk

This page is in Work!

"Hierarchical" Styles in Sidebar

Foreword

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

This description refers to the LibreOffice 7.2 version on Windows 11.

Link to the Video

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

Zellvorlagen in Calc

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

You can also create Cell Styles with multiple changed attributes.

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.

Notes

 Note 
 The "Default" cell style should remain untouched.
 Changes to it will affect the cell styles below it in the hierarchy.
 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

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.