I'm watching some tutorials on how to make spreadsheets but the tutorial is for MS Excel. In this tutorial the instructor makes creates a cell that is formatted and saves it as a cell style for later use in other headings. I cannot figure out how to do this in Calc. Can anyone please explain it to me?
You can find cell styles in the sidebar (F11). You can change the default style (right-click on the style), or create a new one.
If you click New or Change, you can enter your changes in the appearing dialog box.
Please take a look at the button with + icon at the right part of the screenshot on answer by @ebot (between paint bucket and update arrows). It's the New Style from Selection that you are probably after, i.e. it will create a style with settings that you have applied to the selected cell. It's also available in menu Styles.
Hello,
to create a new cell style do the following
View -> Sidebar (or use STRG+F5)
on the rightmost icon bar (Breeze icon style)
on top bar (Breeze icon style)Right Click -> NewOKNote: 1 Another shortcut to the styles dialog is via Styles -> Manage Styles (or F11, if not overriden by an OS shortcut)
Note: 2 Another starting point could be to Right Click -> Styles -> Edit Styles while focus is in a cell.
If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.
I have already tried this, but it does not save the formatting in the cell that I have already created.
:-) "In this tutorial the instructor makes creates a cell that is formatted and saves it as a cell style for later use in other headings. I cannot figure out how to do this in Calc"
That's why we have detailed descriptions after the brief question ;-)
Asked: 2019-09-02 11:24:30 +0100
Seen: 55 times
Last updated: Sep 02
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
