Cell Styles in Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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 
in the sidebar ( Ctrl + F5 ) and select "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 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 desired color, then click .
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 .
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 .
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
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 .
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 .
In the "Font" tab, select the Size.
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 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.
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:
|
|
Note:
|
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:
Any questions?
For questions on this topic go to:
Get Involved
Join us today and help us to make it even better!
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.