Shortcut Key Combinations in Microsoft Excel 2003 or Earlier

The following tables describe Alt+key combinations in Microsoft Excel 2003 or earlier supported versions of Microsoft Excel that enable you to activate Crystal Ball’s Define, Run, Analyze, and Help menu commands and chart windows commands without using the mouse. For shortcut keys in Microsoft Excel 2007 or later, see Shortcut Key Combinations in Microsoft Excel 2007 or later. For commands and shortcut keys used by Crystal Ball products in all supported versions of Microsoft Excel, see Crystal Ball Commands and Shortcut Keys in All Supported Versions of Microsoft Excel.

Note:

Oracle tries to avoid keyboard shortcut conflicts; if a key combination is the same as one on a Microsoft Excel menu, you can use the down arrow key to access the command you want. Commands are listed in the same order in which they are displayed in menus.

Shortcut key tables for Microsoft Excel 2003 or earlier:

Table 12. Crystal Ball Define Menu Commands, Microsoft Excel 2003 or Earlier

Button

Command

Command Action

Keystrokes

Define Assumption button

Define Assumption

Opens the Define Assumption dialog to define a Crystal Ball assumption cell

Alt+n, a

Define Decision button

Define Decision

Opens the Define Decision Variable dialog to define a Crystal Ball decision variable cell

Alt+n, d

Define Forecast button

Define Forecast

Opens the Define Forecast dialog to define a Crystal Ball forecast cell

Alt+n, f

Select All Assumptions button

Select All Assumptions

Selects all assumption cells on the active worksheet

Alt+n, m

Select All Decisions button

Select All Decisions

Selects all decision variable cells on the active worksheet

Alt+n, i

Select All Forecasts button

Select All Forecasts

Selects all forecast cells on the active worksheet

Alt+n, r

n/a

Select

Selects specified Crystal Ball data cells

Alt+n, s

n/a

Freeze

Excludes specified Crystal Ball data cells from a simulation

Alt+n, z

Copy Data button

Copy Data

Copies Crystal Ball cell definitions to specified cells

Alt+n, c

Paste Data button

Paste Data

Pastes copied Crystal Ball cell definitions into specified cells

Alt+n, p

Clear Data button

Clear Data

Removes Crystal Ball cell definitions from specified cells

Alt+n, e

n/a

Cell Preferences

Opens the Cell Preferences dialog

Alt+n, l

Table 13. Crystal Ball Run Menu Commands, Microsoft Excel 2003 or Earlier

Button

Command

Command Action

Keystrokes

Start Simulation button

Start Simulation

Begins running a Crystal Ball simulation

Alt+r, s

Continue Simulation button

Continue Simulation

Resumes a stopped simulation

Alt+r, c

Reset Simulation button

Reset Simulation

Clears generated simulation data (Crystal Ball data cells remain defined)

Alt+r, r

Stop Simulation button

Stop Simulation

Stops a simulation

Alt+r, s

Single Step button

Single Step

Steps through a simulation one trial at a time

Alt+r, i

OptQuest button

OptQuest

Starts OptQuest for results optimization (if available)

Alt+r, o

Predictor button

Predictor

Starts Predictor for time series analysis

Alt+r, p

n/a

More Tools

Offers the Crystal Ball general and integration tools for additional analysis and charting

Alt+r, t

n/a

Batch Fit (general)

Automatically fits selected continuous probability distributions to multiple data series

Alt+r, t, f

n/a

Bootstrap (general)

Addresses the reliability and accuracy of forecast statistics

Alt+r, t, b

n/a

Correlation Matrix (general)

Rapidly defines and automates correlations of assumptions

Alt+r, t, c

n/a

Data Analysis (general)

Loads data from spreadsheets directly into Crystal Ball forecast charts

Alt+r, t, y

n/a

Decision Table (general)

Evaluates the effects of alternate decisions in a simulation model

Alt+r, t, d

n/a

Scenario Analysis (general)

Displays what inputs created particular outputs

Alt+r, t, s

n/a

Tornado Chart (general)

Individually analyzes the impact of each model variable on a target outcome

Alt+r, t, t

n/a

2D Simulation (general)

Independently addresses uncertainty and variability using a two-dimensional simulation

Alt+r, t, 2

n/a

Enterprise Performance Management (integration)

If available, enables Crystal Ballto run simulations on Enterprise Performance Management data using Smart View

Alt+r, t, m

n/a

Strategic Finance (integration)

If available, opens the Strategic Finance Setup wizard for setting up a workbook that allows Crystal Ball to run with Strategic Finance data

Alt+r, t, e

n/a

Compare Run Modes

Compares simulation run time in Normal and Extreme speed

Alt+r, t, r

n/a

Save Results

Saves current simulation results for later display and analysis

Alt+r, v

n/a

Restore Results

Restores saved results files for display and analysis

Alt+r, e

Run Preferences button

Run Preferences

Opens the Run Preferences dialog for setting trials, sampling, and other run preferences

Alt+r, u

Table 14. Crystal Ball Analyze Menu Commands, Microsoft Excel 2003 or Earlier

Button

Command

Command Action

Keystrokes

Assumption Charts button

Assumption Charts

Opens the Assumption Charts dialog so you can display or manage assumption charts

Alt+a, a

Forecast Charts button

Forecast Charts

Opens the Forecast Charts dialog so you can display or manage forecast charts

Alt+a, f

Overlay Charts button

Overlay Charts

Opens the Overlay Charts dialog so you can display existing or create new overlay charts

Alt+a, o

Trend Charts button

Trend Charts

Opens the Trend Charts dialog so you can display existing or create new trend charts

Alt+a, t

Sensitivity Charts

Sensitivity Charts

Opens the Sensitivity Charts dialog so you can display existing or create new sensitivity charts

Alt+a, s

Scatter Charts button

Scatter Charts

Opens the Scatter Charts dialog so you can display existing or create new scatter charts

Alt+a, s

n/a

OptQuest Charts

If OptQuest is available, displays OptQuest charts following an optimization

Alt+a, q

n/a

Predictor Charts

If Predictor is available, displays Predictor charts following a time series forecast

Alt+a, p

n/a

Open Selected Cells

Opens associated charts for selected cells

Alt+a, n

n/a

Cascade

Arranges open charts for easier viewing

Alt+a, c

n/a

Close All

Closes all open charts

Alt+a, l

Create Reports button

Create Report

Opens the Create Report dialog so you can create a report with data and charts for the simulation and results

Alt+a, r

Extract Data button

Extract Data

Copies selected simulation data to a worksheet for additional analysis

Alt+a, d

Table 15. Crystal Ball Help Menu Commands, Microsoft Excel 2003 or Earlier

Button

Command

Command Action

Keystrokes

n/a

Technical Support

Displays the main Crystal Ball Web page with a link to Crystal Ball technical support

Alt+h, b, t

Crystal Ball Help button

Crystal Ball Help

Displays online help for Crystal Ball

Alt+h, b, h

n/a

Crystal Ball Documentation

Displays a list of available online documentation for Crystal Ball

Alt+h, b, c

n/a

Oracle EPM Documentation

Displays the OTN index for Oracle Enterprise Performance Management documentation, including Crystal Ball

Alt+h, b, d

n/a

Examples Guide

Displays a list of available example models so you can load the choice into Crystal Ball

Alt+h, b, e

n/a

Welcome Screen

Displays a Welcome screen that lets you automatically activate the process capability features for quality programs such as Six Sigma or set percentile preferences frequently used in the oil and gas industry

Alt+h, b, w

n/a

Licensing

Displays the Activate a License dialog so you can enter a serial number and activate a Crystal Ball license

Alt+h, b, l

n/a

About Crystal Ball

Offers version and other information about the current Crystal Ball release including the username

Alt+h, b, b