Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Microsoft Excel and OpenOffice.org, new spreadsheet files always come with three sheets by default (i.e. Sheet 1, Sheet 2, Sheet 3).

How to I change the default to just one sheet in OpenOffice.org??

share|improve this question

2 Answers 2

up vote 3 down vote accepted

Make use of templates.

  1. Open a blank workbook
  2. Remove the worksheets as required
  3. File > Templates > Save
    • Templates dialog will popup
  4. Give your template a name (Note the category folder you are in)
  5. Click OK

You've now saved a version of a workbook to use as a template. All you need do is set it up to open as the default.

  1. File > Templates > Organize
    • Template Management dialog window will appear
  2. In the left pane, navigate to where you save the template previously created
  3. Click Commands
  4. Select Save As Default Template
  5. Click Close

Now, the next time you fire up Calc, the template you created will open up ready for you to use instead of the previous default.

share|improve this answer
    
Got it, thanks! –  hpy Aug 26 '10 at 4:10
    
You have no idea how much time I wasted trying to figure this out... –  MathematicalOrchid Apr 8 '13 at 19:12

In open Office Calc u can simply go to: Insert > Sheet (or.. Sheet from file if u want to import one from another file) and u can set it active by using the sheet Arrows at the bottom of the screen to the left.

btw: the new sheet will be added BEFORE Sheet1 not after Sheet3 and u can drag the sheets to re-arrange them the way u need.

sorry didnt read the topic very well (:

share|improve this answer
    
-1 For not even reading the question. It's about opening a new workbook with just one sheet, not adding a new worksheet to a current one. –  random Aug 26 '10 at 2:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.