| • | To display the CELLSHEET MENU, select Menu (press b). |
| • | To display a help screen for common tasks, select Help from the CELLSHEET MENU. |
| • | To exit the application, select Quit CellSheet from the CELLSHEET MENU. |
| • | Press ‘ or y 5 to: |
| - | Return to the main menu from a submenu. |
| - | Return to the spreadsheet from the main menu. |
|
Menus |
Functions |
|||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
File Menu |
||||||||||
|
1: Open... |
Opens an existing spreadsheet file. |
|||||||||
|
2: Save As... |
Saves the current spreadsheet with the same name or with a different name. |
|||||||||
|
3: New... |
Creates a new spreadsheet and allows you to use a new or existing name. |
|||||||||
|
4: Delete... |
Deletes a spreadsheet. You cannot delete the currently open spreadsheet. |
|||||||||
|
5: Format... |
Sets up formatting options. (Default values are highlighted.) AutoCalc: Y N Cursor Mvmt: † ~ Init Help: Y N Show: FMLA VALUE |
|||||||||
|
6: Recalc |
Recalculates the spreadsheet (only needed when the autocalculation feature in the FORMAT menu is turned off). |
|||||||||
|
Edit Menu |
||||||||||
|
1: Go To Cell... |
Moves the cursor to a specific cell. |
|||||||||
|
2: Undelete Cell |
Retrieves the contents of the cell that you just deleted or cleared. |
|||||||||
|
3: Clear Sheet... |
Deletes all data from the current spreadsheet. |
|||||||||
|
4: Select Range... |
Selects a range of cells. |
|||||||||
|
5: Cut |
Cuts the contents and formulas from the currently selected cell, or range of cells, and places them on the clipboard. Shortcut key: _ |
|||||||||
|
6: Copy |
Copies the contents and formulas from the currently selected cell, or range of cells, and places them on the clipboard. Shortcut key: ` |
|||||||||
|
7: Paste |
Pastes the contents and formulas that were just cut or copied to the clipboard into the current cell. Shortcut key: a |
|||||||||
|
Options Menu |
||||||||||
|
1: Statistics... |
Calculates linear regression for the currently selected cell range. 3: Linear Regression - LinReg(ax+b) |
|||||||||
|
2: Fill Range... |
Fills a range of cells with a formula, number, or text.
|
|||||||||
|
3: Sequence... |
Fills a range of cells with a sequence of numbers. 1st Cell: seq( DownRight |
|||||||||
|
4: Import/Export ... |
Imports and exports calculator files such as lists, matrices, or variables. |
|||||||||
|
5: Sort... |
Sorts a range of cells in ascending or descending order. |
|||||||||
|
6: Col Decimal... |
Sets the decimal mode display for a column. The calculator decimal mode display (accessed by pressing z) does not affect the CellSheet™ application. |
|||||||||
|
Charts Menu |
||||||||||
|
1: Scatter... |
Displays a scatter chart for a range of cells. XRange: YRange 1: YRange 2: YRange 3: Title: AxesOn AxesOff DrawFit Draw Notes:
|
|||||||||
|
2: Scatter Window |
Displays the parameters for the viewing window for the scatter chart so that you can change the values. Xmin= Xmax= Xscl= Ymin= Ymax= Yscl= Draw Save |
|||||||||
|
3: Line... |
Displays a line chart for a range of cells. XRange: YRange 1: YRange 2 : YRange 3: Title: AxesOn AxesOff DrawFit Draw Notes:
|
|||||||||
|
4: Line Window... |
Displays the parameters for the viewing window for the line chart so that you can change the values. Xmin= Xmax= Xscl= Ymin= Ymax= Yscl= Draw Save |
|||||||||
|
5: Bar... |
Displays a bar chart for a range of cells. Categories: Series1: Ser1Name: Series2: Ser2Name: Series3: Ser3Name: Title: Vertical Horiz DrawFit Draw Notes:
|
|||||||||
|
6: Bar Window |
Displays the parameters for the viewing window for the bar chart so that you can change the values. Barmin= Barmax= Draw Save |
|||||||||
|
7: Pie... |
Displays a pie chart for a range of cells. Categoreis: Series: Number Percent Title: Draw: |
|||||||||