	Related Topics:
	Analysis Workbooks

Sheet Options

You can determine the appearance of the spreadsheet and which options are allowed within it by choosing Sheet Options > Format and View > More Settings > Sheet Options to open the Sheet Options window.

Allow
- Clear the Selections option to prevent users from selecting cells in the spreadsheet.
- Clear the Fill Range option to prevent users from filling a range of cells using the cross-hair that appears on the bottom right corner of the selected cell(s).
- Clear the Move Range option to prevent users from moving a selected range of cells.
- Clear the Resize Rows and Columns option to prevent users from resizing the rows and columns.
- Clear the Formula Editing option to prevent users from entering or altering any of the formulas in the spreadsheet.
- Clear the In Cell Editing option to force users to only edit the contents of cell using the data entry bar. If you select In Cell Editing, users will also be able to edit the cell contents within the cell itself.
Show
- To hide the gridlines on the spreadsheet, clear the Gridlines option.
- To hide the column headings or the row headings, clear the Column Headings option or the Row Headings option.
- By default, the individual cells display the results of any formulas or calculations. To display the cell formulas instead of the results, select Formulas.
- Choose Cell Types to color the borders of the cells depending on the contents of the cell using the following scheme:
- - Red: the cell contains a formula.
  - Green: the cell contains a value (i.e., number or text).
  - Blue: the cell is blank but formatted.
  - No color: the cell is blank and unformatted.

Tip: When working with an analysis workbook, the last two options can also be turned on and off using the control panel.

Other
- Number of Rows sets the number of rows in the spreadsheet.
- Number of Columns sets the number of columns in the spreadsheet.