13-2-2

Spreadsheet Application Menus and Buttons

kEdit Menu

To do this:

Select this

[Edit] menu item:

 

 

 

Undo the last action, or redo the action you have just undone

Undo/Redo

 

 

Display a dialog box that lets you show or hide scrollbars, and specify the

Options

direction the cursor advances when inputting data

 

 

 

Automatically resize columns to fit the data into the selected cells

AutoFit Selection

 

 

Display a dialog box for specifying column width

Column Width

 

 

Display a dialog box for specifying the number format of the selected cell(s)

Number Format

 

 

Display or hide the Cell Viewer window

Cell Viewer

 

 

Display a dialog box for specifying a cell to jump to

Goto Cell

 

 

Display a dialog box for specifying a range of cells to select

Select Range

 

 

Display a dialog box for specifying cell contents and a range of cells to fill

Fill Range

 

 

Display a dialog box for specifying a sequence to fill a range of cells

Fill Sequence

 

 

Insert row(s)

Insert - Rows

 

 

Insert column(s)

Insert - Columns

 

 

Delete the currently selected row(s)

Delete - Rows

 

 

Delete the currently selected column(s)

Delete - Columns

 

 

Delete the contents of the currently selected cells

Delete - Cells

 

 

Cut the current selection and place it onto the clipboard

Cut

 

 

Copy the current selection and place it onto the clipboard

Copy

 

 

Paste the clipboard contents at the current cell cursor location

Paste

 

 

Select everything in the spreadsheet

Select All

 

 

Sort cell(s) on the spreadsheet

Sort

 

 

Search for strings in the cell(s) on the spreadsheet

Search

 

 

Search for strings in the cell(s) on the spreadsheet again

Search Again

 

 

Clear all data from the spreadsheet

Clear All

 

 

kGraph Menu

You can use the [Graph] menu to graph the data contained in selected cells. See “13-9 Graphing” for more information.

kCalc Menu

The [Calc] menu includes commands to perform the following calculations.

Statistical calculations (Single-variable and paired-variable statistics, regression, tests, confidence interval, distribution, inverse distribution)

Cell calculations (row, col, count, cellIf) and list calculations

For more information, see “13-6 Statistical Calculations” and “13-7 Cell and List Calculations”.

20090601