Videos/Cell Styles in Calc

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

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 [[Media:Calc - Sidebar Styles Icon Cell styles+Tipp.png|Cell styles]] in the sidebar  and select [[Media:Calc - Sidebar Styles Hirarchical.png|"Hierarchical"]] at the bottom to see the hierarchy.

Cell styles with different backgrounds


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.

In the [[Media:01 Screenshot 2021-11-04 165124.png|Cell Style dialog]], enter a name for the new Cell style in the "Organiser" tab.

In the [[Media:02 Screenshot 2021-11-04 165144.png|"Background"]] tab, select the button and [[Media:03 Screenshot 2021-11-04 165230.png|choose the desired color]], then click.

Now select the cells that should get a different color.

Double click on the new Cell style and [[Media:04 Screenshot 2021-11-04 165340.png|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.

In the [[Media:05 Screenshot 2021-11-04 165500.png|Cell Style dialog]], enter a name for the new Cell style in the "Organiser" tab.

In the [[Media:06 Screenshot 2021-11-04 165602.png|Border tab]], select the Line Style, -Color and -Width, then click the "Set for All Four Borders" icon at the top and klick.

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

Double-click on the new Cell style [[Media:07 Screenshot 2021-11-04 165647.png|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


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.

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

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

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.

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.

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 that contains the cell style you want to copy.

Now insert the empty cell in a suitable place 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.

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

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