Related Topics:

Ribbon

Sheet Tab

The Sheet tab is visible when you view folios, general spreadsheets or analysis workbooks.

Format and View

  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 allows you to select the alignment properties of the selected text.

  Borders allows you to customize the borders of selected cells.

  Column Width opens the Column Width window, which allows you to specify the width of the selected column. 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. This will open the Default Column Width window, which allows you to set a default column width.

  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 combines selected cells to form one cell.

  Unmerge Cells separates merged cells into the original individual cells.

  More Settings

You can also freeze several consecutive rows at once by highlighting a cell on each row to be locked and then clicking Freeze Panes.

The Cell Protection setting is especially useful when your spreadsheet or report contains a mix of data and formula cells where a user may inadvertently overwrite a cell containing a formula.

Sheet Actions

   Function Wizard opens the Function Wizard, which helps you to build functions in analysis workbooks. 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 for, then click Chart Wizard and select the area you want to place the chart on.

  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. Note the following:

Rows/Columns

  Delete deletes the selected cells. Note that when the cells are deleted, the information inside the cells is also deleted.

   Insert allows you to insert 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.

Transfer Data

  Send to Excel exports all sheets to an Excel file.

  Send to Word exports the current sheet to a Word file. A Word document opens with the data from the current sheet displayed as a Word table.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.