 |
 |
|
 |
 |
|
 |
 |
 |
The Sheet tab is visible when you view data sheets and general spreadsheets.
Format Cells opens the Format Cells
window, which provides several ways to change the way data are displayed
in a cell or range of cells:
Number tab - sets the numbering format of a cell. Anything you type in the cell will be automatically formatted based on your selection. For example, if you select the number format and specify 3 decimal places, typing the value 1.2 in the cell will automatically display it as 1.200.
Alignment tab - sets the horizontal, vertical alignment and indentation text in a cell. Includes text control options such as wrap text, shrink to fit, merge cells, as well as text direction.
Font tab - sets the font, style, color, size and effects of the selected text.
Border tab - applies borders around the selected cell(s) and controls the line style, thickness and color of the border lines.
Fill tab - sets the background color of the selected cell(s). You can also apply a pattern style and choose a pattern color.
Recalculate
Formulas forces a recalculation of all formulas in the spreadsheet.
Defined Names
applies only to general spreadsheets. It allows you to create and manage
variable names that can be referenced in any function. You can define
a name for any spreadsheet cell or data sheet or function. Names can help
make formulas in the spreadsheet easier to understand and maintain.
The following commands apply only to general spreadsheets.
Function Wizard opens a function
wizard that helps you to build functions that utilize a referenced
analysis (data source).
Insert Function opens a function
wizard that helps you to build functions that return results from
mathematical values (e.g., sine, pi or averages).
Chart Wizard
allows you to create new plots and charts based on the current spreadsheet.
To use, select a range of cells for which you would like to create a chart,
then click Chart Wizard and select
the area where you want to place the chart.
AutoSum
allows you to compute the sum of the values in a range of selected cells.
If a cell range is not selected, the command computes the sum of the values
in the cells directly above the current cursor location.
Sort allows you to reorder the selected data either
in ascending or descending order. Note that you may need to be careful
when sorting certain types of data in order to prevent errors in analysis.
If your analysis takes into account the order position of a data point (1st, 2nd, 3rd, etc. position), sorting may result in an inaccurate analysis.
If the range of cells that you wish to sort contains blank cells, the blank cells may be put in the first position (ascending order) or the last position (descending order).
Insert
inserts new cells at the current cursor location and moves the existing
cells based on the specified direction. If a range of cells is selected
in the sheet, then the same number of cells will be inserted.
Delete
deletes the selected cells and moves the remaining cells based on the
specified direction. Note that when the cells are deleted, the information
inside the cells is also deleted.
Send to Excel exports all sheets to an Excel file.
Send to Word
exports the current sheet to a Word file.
© 1992-2018. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |