Related Topics:
	Ribbon

Sheet Tab

The Sheet tab is visible when you are working with an analysis workbook.

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

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

1. • Sheet Options 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 report contains a mix of data and formula cells where a user may inadvertently overwrite a cell containing a formula.

1. • 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 spreadsheet cell or data source.

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 in order prevent errors in analysis. Note the following:

1. • If your analysis takes into account the order position of a data point (1st, 2nd, 3rd, etc. position). Sorting may result to an inaccurate analysis.

   • If the range of cells that you wish to sort contain 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.

Rows/Columns

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

1. • Shift Cells Left shifts the cells to the left to accommodate the deleted cells.

   • Shift Cells Up shifts the cells up to accommodate the deleted cells.

   • Entire Row deletes the row(s) containing the selected cell(s). All subsequent rows are shifted up to accommodate the deleted cells.

   • Entire Column deletes the column(s) containing the selected cell(s). All subsequent columns are shifted left to accommodate the deleted cells.

  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.

1. • Shift Cells Right shifts the cells to the right to accommodate the inserted cells.

   • Shift Cells Down shifts the 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.

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.