[Solved] Create new spreadsheets with only Sheet1

[compiler]

I suspect this is easy, but


When I start a new spreadsheet, it starts with 3 sheets and will print Sheet 1
as the header. I have to delete sheets 2 and 3 and turn off header.

How can I have a new spreadsheet start off that way?

Mel, using 4.xx

Edit: Changed subject, was when starting a new spreadsheet how do I...  Make your post understandable by others  -- MrProgrammer, forum moderator

[RoryOF]

Leave them alone; they don't do any harm, and when your spreadsheet becomes more advanced you may need extra sheets to present results.

[compiler]

Thanks for the quick response. But it still prints SHEET1 as a heading. I would like the default be to NOT print SHEET1.
I can create this and save it and always open it for any new spreadsheet, but can't I do it so that opening a new spreadsheet does this?
I'm sure it's very basic.

Mel

[MrProgrammer]

When I start a new spreadsheet, it starts with 3 sheets and will print Sheet 1 as the header. I have to delete sheets 2 and 3 and turn off header. How can I have a new spreadsheet start off that way?

Create a spreadsheet with the properties that you want:
• Single sheet   (use Edit → Sheet → Delete → …)
• No header     (use Format → Page → Header → uncheck Header on)

Save this as a template and make that template the default for Calc. I find it helpful to put styles that I often use in the default template,
[Tutorial] Creating a new default template

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Zizi64]

You can set this property in the LibreOffice:

LO Calc Defaults.png (19.83 KiB) Viewed 1345 times