Section 40. Create a New Spreadsheet

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.


Unlike Writer, Wizards offer no help for creating spreadsheets.


A quick way to start is to use the QuickStarter icon on the taskbar. Right-click this icon; from the context menu, choose any program to launch it, use a template, or load an existing document. The QuickStarter icon is available only if the Load during system startup option is enabled. To enable this option, select the Memory category in the options list in the Options dialog box of any program.

40. Create a New Spreadsheet

Although Calc does not come with templates when you first install, you can easily create a template to reuse later. This task shows you how to open a blank spreadsheet. 18 Use a Template explains how to create a new spreadsheet based on a template you may have created and saved previously.

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.

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.

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 ), and HTML ( .html ).


Although you can also use the File, Save command to save a new file for the first time, it's a good idea to use the Save As command. If you have already saved a file, using Save does not open the Save As dialog box but instead automatically saves any changes to the existing filea problem if you were planning to save the file with a new name so that you could preserve the original file. 2, Firefox, and Thunderbird for Windows All in One
Sams Teach Yourself 2, Firefox and Thunderbird for Windows All in One
ISBN: 0672328089
EAN: 2147483647
Year: 2005
Pages: 232
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: