Related Topics:
	Ribbon

Home Tab

The Home tab contains commands related to using the Clipboard and printing data sheets.

Clipboard

  Paste

1. • Paste pastes the contents of the Clipboard into the current folio or spreadsheet.

   • 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 folio or spreadsheet.

   • Paste Formats pastes only the formats from the Clipboard to the current folio or spreadsheet.

   • Paste Transposed Values pastes only the transposed values from the Clipboard to the current folio or spreadsheet.

  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 select Format Painter. Next, click the text to which the format properties are to be applied. These commands are only available when you are viewing a spreadsheet.

Edit

  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 content in spreadsheets.

1. • 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. The commands in the submenu are available only when you are viewing a spreadsheet, except for Alignment, Font Color, Select Font, Custom Number and Row Height, which are also available when working with standard designs and robust designs.

1. • 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).

   • 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 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.

  Spelling activates the Spell Check utility, which allows you to check the spelling within the current sheet.

Print

  Print sends the current data sheet or spreadsheet to the printer.

  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.  

  Page Setup opens the Page Setup window, which allows you to specify printing options.

Tools

  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.

Launch

  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.