AutoFormat styles in Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
The video "AutoFormat Styles in Calc - LibreOffice" links to this page, which contains further information and details.
Link to the video
Link to the video (in German [DE]):
Apply AutoFormat Styles
Tables should often look representative.
Doing this manually every time, especially when you need to create tables frequently, is very time consuming.
To simplify this work, we can use the function "AutoFormat Styles …" to automatically apply desired formats to a table or to a selected range of cells.
Select at least 4 x 4 cells, or larger, as large as the table should be later, including the required column and row headings and sums to be automatically formatted.
Then select▸ .
In the "AutoFormat" dialog, you can choose which formatting – ("Numbers", "Font", "Orientation", "Outline", "Pattern" and / or "Automatically adjust width / height") - to AutoFormat want to involve.
Select the desired "Format" and click on.
Redefine an AutoFormat Style
If you don't like any of the given formats, you can also create a format ourselves.
To do this, format an area on the worksheet of at least 4 x 4 cells, or larger, as large as the table should be later, including the headings for rows and columns and the display of sums.
Now you define all details for the Style.
This affects the font and size, orientation, border and colors.
When the table is complete, mark the entire table space and select▸ .
In the dialog, "AutoFormat" click on.
In the opening dialog, "Add AutoFormat" you give a Name, e.g. "Format_01", for the new format and click on.
The newly created format "Format_01" will now be displayed in the "AutoFormat" dialog with the name on the left.
Close the dialog with.
You can now use the new format "Format_01".
Documentation / Manuals
Here you will find the Documentation / Manuals:
For questions on this topic go to:
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.