How can I change the default font in Calc

[mjw72652]

All the info I can find is based on old versions of LibreOffice. Using the newest version of 24.8.3.2, how do I change the default font for all new spreadsheets?

[EarnestAl]

The same as for previous versions.

1. Open a blank spreadsheet

2. In the Sidebar, click on the Styles icon to open the Styles pane.

3. The pane initially shows Cell Styles (first icon on left at the top).
   

4. Right click Default, select Edit style

5. In the dialogue that opens, select the Fonts tab. Select your desired font and font size, change nothing else. OK

6. Click File > Templates > Save as template

7. In the dialogue, type a suitable name, select an appropriate location such as My Templates, tick the box Set as default template. Save

To remove the default template status if no longer needed, click File > Templates > Manage templates. FInd the template with a green tick, right click it and select *Reset default. Or right click another template and select Set as Default to make that default template.

[mjw72652]

Thank you. Got it.

[fpy]

@EarnestAl

same

Change default font in calc

You need to create a “default template” for Calc to set your own personal settings as the base for new spreadsheets. There are three steps. (1) First, open Calc, and simply save its current settings as your own “template”, following this menu sequence: File > Templates > Save as template... then give a name, e.g. calc-noto-sans (or whatever, that’s just a random example for these instructions, of course) and Assign to the “My Templates” category. Click OK. (2) Next, you can use that template…

How do you set the default font in LibreOffice Calc (v6.2)

Hello, perform the following: Open a new Calc spreadsheet Go to Styles -> Manage Styles (or F11) Click icon Cell Styles (leftmost icon below Styles*) Right click on Default → Modify -> Tab: Font Set your preferred font + options Click OK Menu File -> Templates -> Save as Template Provide a Template Name (e.g. MyCalcTemplate) Select a Template Category (e.g. My Templates) Important Check option [x] Set as default template Click Save Close your document (no further save required) and op…

[mjw72652]

Got it. Thank you.