Creating a Spreadsheet

To create a Spreadsheet, use the Insert tab→Spreadsheet→New command to bring up the Create new spreadsheet dialog (Figure 11.1).

 

Alternatively, if a Data Navigator is open, you can right-click on the Data Navigator and choose Create new spreadsheet from the pop-up menu.

 

Creating a Spreadsheet from the Insert tab.

Creating a Spreadsheet from the Insert tab.

 

 

 

Figure 11.1  Create new spreadsheet Dialog

Figure 11.1  Create new spreadsheet Dialog

 

 

 

The option for Open Data Grid is selected by default.  You can additionally choose to open the Data Navigator. If the Data Navigator is already open then the option will be inaccessible.

 

When you are finished, click OK. The Create new spreadsheet dialog will disappear. A new spreadsheet will appear on your screen, similar to the image below.

 

The cells of spreadsheet may be filled with text, numbers or tokens.

 

Cells of the spreadsheet may reference each other much like Microsoft Excel following the same conventions of Excel.

 

Formulas may be created in the cells much like Microsoft Excel.

 

New, Empty Spreadsheet

New, Empty Spreadsheet