![]() |
Related Topics: | ![]() |
![]() |
![]() |
|
![]() |
![]() |
![]() |
The Home tab contains commands related to using the Clipboard and printing.
Paste
Paste All pastes the formats, formulas and values of the contents of the Clipboard to the current folio or spreadsheet.
Paste Values pastes only the values from the Clipboard to the current sheet.
Paste Formulas pastes only the formulas from the Clipboard to the current sheet.
Paste Format pastes only the formats from the Clipboard to the current sheet.
Cut
cuts the selected text or graphic to the Clipboard. Data stored on the
Clipboard can be pasted into this and other applications.
Copy
copies the selected text to the Clipboard. Data stored in the Clipboard
can be pasted into any data sheet within the application or in other documents.
If you are copying a plot, the way the plot is copied will depend on your
selection in the Plot Copy Type
field in the Synthesis Setup window.
Format Painter
allows you to copy the format properties of text in a sheet and apply
it to other text. To use the Format Painter, select the text with the
format properties that are to be copied and then choose Format
Painter. Next, click the text to which the format properties are
to be applied.
Redo
reapplies the previously canceled action. You can redo multiple actions
by choosing Redo again.
Undo
cancels the last editing change you made.
Delete
deletes the selected text.
Clear
deletes the selected text.
Clear All deletes the contents and format of the selected cell(s), but does not delete the actual cell(s).
Clear Values deletes only the contents of the selected cell(s). The format will be retained.
Clear Formats deletes only the format of the selected cell(s). The contents will be retained.
Format Selection
opens the Format submenu, which contains the following commands.
Alignment allows you to set the alignment properties of the selected text.
Borders allows you to customize the borders of selected cells.
Font Color opens the Color window, which allows you to set the color of the selected text.
Fill Color opens the Color 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).
Select Font opens the Font window, which allows you to set the font, style and size of the selected text.
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.
Column Width Style allows you to set the column width of the selected cells.
Span Evenly spans the columns across the spreadsheet with equal width.
Span Proportionally keeps the ratio of the column widths to span across the spreadsheet after they have been resized.
Keep As Set By User keeps the column width settings defined by the user.
Column Width opens the Column Width window, which allows you to set the column width of the selected cells. 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. Click OK to accept the column width selections and apply them to the current Spreadsheet. Click Cancel to cancel any changes made in the Column Width window. You can change the default column width by clicking Change Default. This will open the Default Column Width window, which allows you to set a default column width. This window has the same options as the Column Width window.
Row Height opens the Row Height window, which allows you to set the row height of the selected cells. The Row Height window works the same way the Column Width window works, with the additional option of automatically setting the row height based on contents.
Freeze Panes allows 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. Changes cannot be made to a frozen row.
Merge Cells combines selected cells to form one cell.
Unmerge Cells separates merged cells into the original individual cells.
Select All
selects all of the cells in the currently active sheet.
Find
opens the Find window, which allows you
to search through the active sheet for text and/or numbers in values or
formulas and, if desired, replace the material found.
Spelling
activates the Spell Check utility, which
allows you to check the spelling within the current sheet.
Print
sends the current data sheet or spreadsheet to the printer.
Page Setup opens the Page
Setup window, which allows you to specify printing options.
Print Preview
opens the Print Preview window, which
allows you to view how the current data sheet or spreadsheet will appear
on the printed page.
RGA Monte Carlo opens
the RGA Monte Carlo utility, which
uses simulation to generate a single data set containing values that are
distributed according to the Crow-AMSAA (NHPP) model with specified beta
and lambda parameters.
Quick
Statistical Reference opens the Quick
Statistical Reference utility, which allows you to calculate common
statistical values such as median ranks, chi-squared values and student's
t values. It also includes a polynomial interpolation/extrapolation function,
which allows you to obtain new data points from a set of known data points
that you provide.
Another Synthesis Application
provides a drop-down list of the other Synthesis applications that are
installed on your computer. When you click an icon, the same database
will automatically be opened in the new application.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.