How to lock font on spreadsheet

When a new cell is added it always goes to Arial 10pt and I want to lock spreadsheet to Cambria 13pt

Learn to use styles and templates.

Hello,

  • Open an new, empty calc file
  • Open Styles Manager ( View -> Styles or ´F11`)
  • Click icon leftmost beneath word Styles (shows Cell Styles when hovering over)
  • Right click on *Default* -> Modify... -> Tab: Font and set your desired values
  • Click OK
  • File -> Templates -> Save as Template...
  • Provide a Template Name (e.g. MyDefaultCalc)
  • Select a Template Category (e.g. My Templates)
  • Important Check option [x] Set as default template
  • Click OK
  • Close the calc file (no need for an additional Save operation)
  • Open a new calc file and check you settings working.

Ref.: LibreOffice Help - Creating and Changing Default and Custom Templates

Hope that helps.