 |
 |
|
 |
 |
|
 |
 |
 |
English | Deutsch
The Sheet tab is visible when you view data sheets and general spreadsheets.
Select Font
opens the Font window, which allows you to set the font, style and size
of the selected text.
Font Color
opens the Colors window, which allows you to set the color of the selected
text.
Fill Color
opens the Colors window, which allows you to set the color used to fill
the selected cell(s).
Fill Pattern
opens the Cells Patterns window, which allows you to set the fill color,
pattern color and fill pattern properties of the selected cell(s).
Alignment
sets the alignment properties of the selected text.
Borders
sets the border color and line style of selected cells.
Column Width
opens the Column Width window, which allows you to specify the width of
the selected column(s). Enter the desired width in the input box. You
can select the units of measurement (characters, inches or centimeters)
from the Units drop-down list.
To use the default column width, click Use
Default. You can change the default column width by clicking Change Default.
Custom Number
opens the Format Cells-Number window, which allows you to set the format
for how numbers in the selected cell(s) will displayed.
Merge Cells
applies only to general spreadsheets. It combines selected cells to form
one cell.
Unmerge Cells
applies only to general spreadsheets. It separates merged cells into the
original individual cells.
More Settings
Goto opens the Goto window, which allows you to automatically move the cursor to a particular cell location. Uppercase or lowercase may be used.
Freeze Panes applies you to lock a specific row on the spreadsheet so that the contents of the selected row will always be visible on screen no matter how far you scroll to the right or down. You can also freeze several consecutive rows at once by highlighting a cell on each row to be locked and then clicking Freeze Panes. Changes cannot be made to a frozen row.
Sheet Options applies only to general spreadsheets. It opens the Sheet Options window, which allows you to specify what elements you want to be displayed on the spreadsheet, such as gridlines and row/column headings, and what editing actions can be performed on the spreadsheet, such as the ability to resize rows/columns and select individual cells.
Calculation Options opens the Calculation Options window, which allows you to change formula recalculation, iteration or precision.
Recalculate Formulas forces a recalculation of all formulas in the spreadsheet.
Cell Protection opens the Format Cells window, which allows you to select whether the selected cell(s) will be locked or hidden when you select the Enable Protection command. Cells that are locked cannot be edited when the sheet protection command is enabled.
The Cell Protection setting is especially useful when your sheet contains a mix of data and formula cells where a user may inadvertently overwrite a cell containing a formula.
Enable Protection see Cell Protection.
Defined Names opens the Defined Names window, which allows you to create and manage variable names that can be referenced in any function. You can define a name for any cell, data source or function. Names can help make formulas in the sheet easier to understand and maintain.
The following commands apply only to general spreadsheets.
Function Wizard opens the Function
Wizard, which helps you to build functions. These functions can return
results ranging from mathematical values (e.g., sine, pi or averages)
to reliability metrics based on associated data sheets (e.g., reliability,
probability of failure, expected number of failures, etc.).
Chart Wizard
allows you to create new plots and charts based on the current spreadsheet.
To use, select a range of spreadsheet 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. Note the following:
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).
If the values in two or more columns are related, sorting only one column may result in errors. In that situation, use the Custom Sort command.
Delete
deletes the selected cells and moves the remaining cells based on the
specified direction.
Shift Cells Left moves the remaining cells to the left.
Shift Cells Up moves the remaining cells up.
Entire Row deletes the row(s) containing the selected cell(s). All subsequent rows are shifted up.
Entire Column deletes the column(s) containing the selected cell(s). All subsequent columns are shifted left.
Insert
inserts new cells into the currently active sheet at the current cursor
location. If a range of cells is selected in the sheet, then the same
number of cells will be inserted.
Shift Cells Right moves existing cells to the right to accommodate the inserted cells.
Shift Cells Down moves existing cells down to accommodate the inserted cells.
Entire Row inserts a row of empty cells for each row containing a selected cell. All subsequent rows are shifted down to accommodate the inserted cells.
Entire Column inserts a column of empty cells for each column containing a selected cell. All subsequent columns are shifted right to accommodate the inserted cells.
Send to Excel
exports all sheets to an Excel file.
Send to Word
exports the current sheet to a Word file.
© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.
 |
E-mail Link |