Calc 1.1

Create, Open and Save Workbooks

4 of 8

Saving a Workbook

Every workbook created in Calc must be saved and assigned a name to distinguish it from other workbooks. If you don't name the file, you won't be able to open and update it in the future.

The first time you save a workbook, Calc will prompt you to assign a name through the Save As operation. Additional changes can be made to a named file (text, numbers or formulas) by using the Save operation.

So, how do you know if a file has been named or not? Look at the blue title bar that runs along the top of the screen. If the text, Untitled - OpenOffice.org is displayed in the title bar, as seen in the picture below, the file does not have a name.

Title Bar revealing an unnamed file

If the title bar contains some name other than Untitled - OpenOffice.org, you know that the file has already been named and saved. The document in the example below is named, My first document.sxw.

Title Bar revelaing a named file

To save a new Calc workbook:
  • Choose File Save As from the menu bar.

    File > Save As menu

  • The Save As dialog box appears.
  • Click on the Save In: drop-down menu and locate where the file will be saved. Choose 3 1/2 Floppy (A:) to save the file to a floppy disk or Local Disk (C:) to save the file to your computer.
  • Type a name for your file in the File Name: box.
  • Click the Save button.
To save changes made to an existing workbook:
  • Choose File Save from the menu bar, or

    Click the Save button on the Standard toolbar.

It is a good idea to Save frequently when working in Calc. Losing information is never fun! You can quickly save your spreadsheet by using the quick-key combination Ctrl + S.