40. Create a New Spreadsheet
38 About Sheets and Spreadsheets 41 Open an Existing Spreadsheet 42 Enter Simple Data into a Spreadsheet Calc offers two ways to create new spreadsheets: You can create a completely blank, new spreadsheet (if you choose this approach, you must decide what to put in the spreadsheet and where that information should go), or you can use a spreadsheet template to open a preformatted spreadsheet.16 About Styles and Templates explains what templates are.
18 Use a Template explains how to create a new spreadsheet based on a template you may have created and saved previously.
1. | Request a New Spreadsheet Select Spreadsheet from the File, New menu option. Calc creates a blank spreadsheet. Alternatively, click the New toolbar button to open a new blank Calc spreadsheet quickly. |
2. | Compose Your Spreadsheet Create your spreadsheet in the blank work area of cells that Calc gives you. You'll enter text, numbers, and formulas, depending on the needs of your spreadsheet. You can print your spreadsheet (see 46 Print a Spreadsheet ) at any time. |
3. | Save the Spreadsheet After creating your spreadsheet, select File, Save As and type the name of your spreadsheet. Calc uses the filename extension .ods for your spreadsheet. You can select another file format, such as Microsoft Excel; doing so saves the spreadsheet with the .xls Excel extension. Other file formats include StarCalc (.sdc), Text CSV (.csv), an209 (l). |