The following tables list Alt+key combinations in Microsoft Excel 2007 or later so you can use the Define, Run, Analyze, and Help commands in the Crystal Ball ribbon without using the mouse:
Table 16, Crystal Ball Define Commands, Microsoft Excel 2007 or Later
Table 17, Crystal Ball Run Commands, Microsoft Excel 2007 or Later
Table 18, Crystal Ball Analyze Commands, Microsoft Excel 2007 or Later
Table 19, Crystal Ball Tools Commands, Microsoft Excel 2007 or Later
Table 20, Crystal Ball Help Commands, Microsoft Excel 2007 or Later
For shortcut keys in Microsoft Excel 2003, see Shortcut Key Combinations in Microsoft Excel 2003 or Earlier. For additional commands and shortcut keys available in all currently-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. |
Table 16. Crystal Ball Define Commands, Microsoft Excel 2007 or Later
Button | Command | Command Action | Keystrokes |
|---|---|---|---|
| Define Assumption | Opens the Define Assumption dialog to define a Crystal Ball assumption cell | Alt+c, a |
| Define Decision | Opens the Define Decision Variable dialog to define a Crystal Ball decision variable cell | Alt+c, d |
| Define Forecast | Opens the Define Forecast dialog to define a Crystal Ball forecast cell | Alt+c, f |
| Copy | Copies Crystal Ball cell definitions to specified cells | Alt+c, c |
| Paste | Pastes copied Crystal Ball cell definitions into specified cells | Alt+c, p |
| Clear | Removes Crystal Ball cell definitions from specified cells | Alt+c, e |
| Select | Offers the Select menu, to select assumption, decision variable, and forecast cells | Alt+c, l |
| Select All Assumptions | Selects all assumption cells on the active worksheet | Alt+c, l, a |
| Select All Decisions | Selects all decision variable cells on the active worksheet | Alt+c, l, d |
| Select All Forecasts | Selects all forecast cells on the active worksheet | Alt+c, l, f |
| n/a | Select Some... | Selects specified Crystal Ball data cells | Alt+c, l, s |
| Freeze | Excludes specified Crystal Ball data cells from a simulation | Alt+c, g |
| Cell Prefs | Opens the Cell Preferences dialog to change the appearance and other properties of Crystal Ball data cells | Alt+c, y |
Table 17. Crystal Ball Run Commands, Microsoft Excel 2007 or Later
Button | Command | Command Action | Keystrokes |
|---|---|---|---|
| Start | Begins running a Crystal Ball simulation and resumes a stopped simulation. | Alt+c, s |
| Stop | Stops a simulation | Alt+c, o |
| Reset | Clears generated simulation data (Crystal Ball data cells remain defined) | Alt+c, r |
| Step | Steps through a simulation one trial at a time | Alt+c, i |
n/a | Trials | Sets the number of trials for a Crystal Ball simulation; edits the Trials setting in the Run Preferences dialog | Alt+c, j |
n/a | Save Results | Saves current simulation results for later display and analysis | Alt+c, w, v |
n/a | Restore Results | Restores saved results files for display and analysis | Alt+c, w, e |
| Run Preferences | Opens the Run Preferences dialog for setting trials, sampling, and other run preferences | Alt+c, u |
Table 18. Crystal Ball Analyze Commands, Microsoft Excel 2007 or Later
Button | Command | Command Action | Keystrokes |
|---|---|---|---|
| View Charts | Offers a gallery of charts and chart window management commands; use the Down arrow (Ø) to choose a specific chart | Alt+c, v |
| Assumption Charts | Opens the Assumption Charts dialog so you can display or manage assumption charts | Alt+c, v |
| Forecast Charts | Opens the Forecast Charts dialog so you can display or manage forecast charts | Alt+c, v |
| Sensitivity Charts | Opens the Sensitivity Charts dialog so you can display existing or create new sensitivity charts | Alt+c, v |
| Overlay Charts | Opens the Overlay Charts dialog so you can display existing or create new overlay charts | Alt+c, v |
| Trend Charts | Opens the Trend Charts dialog so you can display existing or create new trend charts | Alt+c, v |
| Scatter Charts | Opens the Scatter Charts dialog so you can display or manage scatter charts | Alt+c, v |
| OptQuest Charts | If OptQuest is available, opens OptQuest charts following an optimization | Alt+c, v |
| Predictor Charts | Opens Predictor charts following a time series forecast | Alt+c, v |
| n/a | Open Selected Cells | Opens associated charts for selected cells | Alt+c, v, n |
| n/a | Cascade | Arranges open charts for easier viewing | Alt+c, v, c |
| n/a | Close All | Closes all open charts | Alt+c, v, l |
| Create Report | Lets you create a report of simulation results by choosing from a gallery of predefined and custom report types | Alt+c, m |
| Assumptions Report | Creates a report of only assumption results | Alt+c, m, a |
| Decision Variables Report | Creates a report of only decision variable results | Alt+c, m, d |
| Forecasts Report | Creates a report of only forecast results | Alt+c, m, f |
| Full Report | Creates a report of all simulation results | Alt+c, m, r |
| Index Report | Creates a report of only Crystal Ball data cell names and locations | Alt+c, m, i |
| OptQuest Report | If OptQuest is available, creates a report of selected OptQuest results following an optimization | Alt+c, m, o |
| Predictor Report | Creates a report of selected Predictor results following a time series forecast | Alt+c, m |
| Custom Report | Creates a report with only selected simulation results | Alt+c, m, c |
| n/a | Report Preferences | Sets various report options | Alt+c, m, p |
| Extract Data | Copies selected simulation data to a worksheet for additional analysis | Alt+c, x |
Table 19. Crystal Ball Tools Commands, Microsoft Excel 2007 or Later
Button | Command | Command Action | Keystrokes |
|---|---|---|---|
| OptQuest | Starts OptQuest for results optimization | Alt+c, q |
| Predictor | Starts Predictor for time series analysis | Alt+c, t, p |
| More Tools | Offers the Crystal Ball general tools and integration tools for additional analysis and charting | Alt+c, t |
| Batch Fit (general) | Automatically fits selected continuous probability distributions to multiple data series | Alt+c, t, f |
| Bootstrap (general) | Addresses the reliability and accuracy of forecast statistics | Alt+c, t, b |
| Correlation Matrix (general) | Rapidly defines and automates correlations of assumptions | Alt+c, t, c |
| Data Analysis (general) | Imports data directly from spreadsheets into Crystal Ball forecasts for further analysis | Alt+c, t, a |
| Decision Table (general) | Evaluates the effects of alternate decisions in a simulation model | Alt+c, t, d |
| Scenario Analysis (general) | Displays what inputs created particular outputs | Alt+c, t, s |
| Tornado Chart (general) | Individually analyzes the impact of each model variable on a target outcome | Alt+c, t, t |
| 2D Simulation (general) | Independently addresses uncertainty and variability using a two-dimensional simulation | Alt+c, t, 2 |
| Enterprise Performance Management (integration) | If available, enables Crystal Ballto run simulations on Enterprise Performance Management data using Smart View | Alt+c, t, m |
| Strategic Finance Setup (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+c, t, e |
| Compare Run Modes | Compares simulation run time in Normal and Extreme speed (if available) | Alt+c, t, r |
Table 20. Crystal Ball Help Commands, Microsoft Excel 2007 or Later
Button | Command | Command Action | Keystrokes |
|---|---|---|---|
| Help | Displays online help for Crystal Ball | Alt+c, h |
| Resources | Displays menus for Crystal Ball technical support, Oracle OTN for downloads, Crystal Ball and EPM documentation, examples, the Welcome screen, and the licensing dialog | Alt+c, n |
n/a | Technical Support | Opens the Crystal Ball Web page with a link to technical support | Alt+c, n, t |
n/a | Crystal Ball Documentation | Displays a list of available online documentation for Crystal Ball | Alt+c, n, c |
n/a | Oracle EPM Documentation | Displays the OTN index for Oracle Enterprise Performance Management documentation, including Crystal Ball | Alt+c, n, d |
n/a | Examples Guide | Displays a list of available example models so you can load the choice into Crystal Ball | Alt+c, n, 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+c, n, w |
n/a | Licensing | Displays the Activate a License dialog for entering a Crystal Ball serial number and activating a license | Alt+c, n, l |
| About [Crystal Ball] | Offers version and other information about the current Crystal Ball release including the username | Alt+c, b |
