After you define assumptions, decision variables, or forecast cells and return to the spreadsheet, you may want to confirm that the cell definitions are defined as you intended.
Note: | For Select dialog help, see “Reviewing Selected Cells” later in this topic. |
To review all data cells of one type:
Select Define, and then one of the Select commands: Select All Assumptions,
; Select All Decisions, 
; or Select All Forecasts, 
.In Microsoft Excel 2007 or later, select Define, then Select and then select one of the Select commands.
Select Define, and then one of the Define commands: Define Assumption,
; Define Decision, 
, or Define Forecast, 
.If you have more than data cell of that type, each is displayed in turn. Repeat steps 3 and 4 to review the definition for each cell.
To review Crystal Ball data cells on any open workbook:
Select Define, and then Select. (In Microsoft Excel 2007 or later, select Define, then Select and then select one of the Select commands.)
By default, the dialog opens in hierarchical Tree view. All the assumptions are listed first, then all the decision variables, and finally all the forecasts.
You can click the Assumption, Decision Variable, and Forecast buttons to show and hide assumptions, decision variables, and forecasts, respectively. If you prefer to view available cells in list format, click the List button,
.Select the cells to review. They can be of any or all types.
Click OK to highlight all the selected cells so you can change their preferences or perform other actions on them.
Note: | You can use the Select dialog to select cells on more than one worksheet but you need to activate each worksheet in turn to review and, if you want, apply a command to all the selected cells. |