Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Starting opening saving"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Starting new spreadsheets, opening and saving spreadsheets}} {{Documentation/CG3Ch1TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Parts of the m...)
 
(Starting new spreadsheets)
Line 6: Line 6:
 
}}
 
}}
 
==Starting new spreadsheets==
 
==Starting new spreadsheets==
A new spreadsheet can be opened from any component of OOo. for example from Writer or Draw.
+
You can create a new, blank spreadsheet from the Start Center (Welcome to OpenOffice.org) or from within Calc or any other component of OOo, for example from Writer or Draw.
  
==== From the menu bar ====
+
====From the Start Center====
 +
Click the '''Spreadsheet''' icon.
 +
 
 +
==== From the Menu bar ====
 
Click '''File''' and then select '''New > Spreadsheet'''.
 
Click '''File''' and then select '''New > Spreadsheet'''.
  
 
==== From the toolbar ====
 
==== From the toolbar ====
Use the '''New Document''' [[Image:New-calc-icon.jpg]] button on the Standard toolbar. (This button is always a page of text from the current component with a black arrow to the right.) Click the drop-down arrow for a choice of what type of document to open (text document, spreadsheet, and so on). Click the button itself to create a new document of the type that is currently open (if a spreadsheet is open, a new spreadsheet document will be created).
+
If a document is open in any component of OOo (for example, Writer), you can Use the '''New Document''' [[Image:New-calc-icon.jpg]] icon on the Standard toolbar. (This icon is always a page of text from the current component with a black down-arrow to the right.) Click the down-arrow for a choice of which type of document to open (text document, spreadsheet, and so on). Click the button itself to create a new document of the type that is currently open. (If a spreadsheet is open, a new spreadsheet document will be created).
  
 
==== From the keyboard ====
 
==== From the keyboard ====
Line 18: Line 21:
  
 
==== From a template ====
 
==== From a template ====
Calc documents can also be created from templates, if you have any spreadsheet templates available. Follow the above procedures, but instead of selecting Spreadsheet from the File menu, select '''Templates and Documents'''. On the Templates and Documents window, navigate to the appropriate folder and double-click on the required template. A new spreadsheet, based on the selected template, opens.
+
Calc documents can also be created from templates, if you have any spreadsheet templates available. Follow the above procedures, but instead of selecting Spreadsheet, select the '''Templates''' icon from the Start Center or '''Templates and Documents''' from the Menu bar or toolbar. On the Templates and Documents window, navigate to the appropriate folder and double-click on the required template. A new spreadsheet, based on the selected template, opens.
  
 
== Opening existing spreadsheets ==
 
== Opening existing spreadsheets ==

Revision as of 01:07, 26 May 2009



Starting new spreadsheets

You can create a new, blank spreadsheet from the Start Center (Welcome to OpenOffice.org) or from within Calc or any other component of OOo, for example from Writer or Draw.

From the Start Center

Click the Spreadsheet icon.

From the Menu bar

Click File and then select New > Spreadsheet.

From the toolbar

If a document is open in any component of OOo (for example, Writer), you can Use the New Document New-calc-icon.jpg icon on the Standard toolbar. (This icon is always a page of text from the current component with a black down-arrow to the right.) Click the down-arrow for a choice of which type of document to open (text document, spreadsheet, and so on). Click the button itself to create a new document of the type that is currently open. (If a spreadsheet is open, a new spreadsheet document will be created).

From the keyboard

If you already have a spreadsheet open, you can press Control+N to open a new spreadsheet.

From a template

Calc documents can also be created from templates, if you have any spreadsheet templates available. Follow the above procedures, but instead of selecting Spreadsheet, select the Templates icon from the Start Center or Templates and Documents from the Menu bar or toolbar. On the Templates and Documents window, navigate to the appropriate folder and double-click on the required template. A new spreadsheet, based on the selected template, opens.

Opening existing spreadsheets

An existing spreadsheet can also be opened from any component of OOo.

From the menu bar

Click File and then select Open.

From the toolbar

Click the Open button Open-icon.jpg on the Standard toolbar.

From the keyboard

Use the key combination Control+O.

Each of these options displays the Open dialog box, where you can locate the spreadsheet that you want to open.

Template:Documentation/Tip

Saving spreadsheets

Spreadsheets can be saved in three ways.

From the menu bar

Click File and then select Save.

From the toolbar

Click on the Save button Save-icon.jpg on the Function bar. If the file has been saved and no subsequent changes have been made, this button is greyed-out and unselectable.

From the keyboard

Use the key combination Control+S.

If the spreadsheet has not been saved previously, then each of these actions will open the Save As dialog box. Here you can specify the spreadsheet name and the location in which to save it.

Template:Documentation/Note


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools