Filter
Top Products
20090601
13-2-2
Spreadsheet Application Menus and Buttons
I
Edit 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
direction the cursor advances when inputting data
Options
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
I
Graph Menu
You can use the [Graph] menu to graph the data contained in selected cells. See
“13-9 Graphing” for more information.
I
Calc 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”.