Ask Your Question
0

How do I create a cell style in Calc?

asked 2019-09-02 11:24:30 +0100

EightBitTaco gravatar image

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?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2019-09-02 11:41:54 +0100

ebot gravatar image

updated 2019-09-02 11:45:50 +0100

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.

image description

If you click New or Change, you can enter your changes in the appearing dialog box.

edit flag offensive delete link more

Comments

Perfect! I didn't see the + before. Thanks!

EightBitTaco gravatar imageEightBitTaco ( 2019-09-02 12:18:10 +0100 )edit
1

answered 2019-09-02 12:12:07 +0100

updated 2019-09-02 12:17:01 +0100

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.

edit flag offensive delete link more

Comments

Aha, great!! Thanks :)

EightBitTaco gravatar imageEightBitTaco ( 2019-09-02 12:17:42 +0100 )edit
0

answered 2019-09-02 11:37:57 +0100

Opaque gravatar image

updated 2019-09-02 12:05:19 +0100

Hello,

to create a new cell style do the following

  • Open a Calc spreadsheet
  • Go to View -> Sidebar (or use STRG+F5)
  • Click on the styles icon image description on the rightmost icon bar (Breeze icon style)
  • Click on the cell styles icon image description on top bar (Breeze icon style)
  • On style Default Right Click -> New
  • Provide a Name (e.g. MyFirstStyle) for the style and make all your settings
  • Click button OK

Note: 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.

edit flag offensive delete link more

Comments

I have already tried this, but it does not save the formatting in the cell that I have already created.

EightBitTaco gravatar imageEightBitTaco ( 2019-09-02 12:09:52 +0100 )edit

This wasn't the question - you asked how to create a new style for latter use and not how to create a new style and immeadiately apply to the current cell.

Opaque gravatar imageOpaque ( 2019-09-02 12:23:07 +0100 )edit

:-) "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 ;-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-09-02 12:28:21 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-02 11:24:30 +0100

Seen: 53 times

Last updated: Sep 02