Table 29 lists shortcut keys for controls that either have no labels or do not have a shortcut key that is highlighted when you press Alt.
Table 29. Shortcut Keys for Controls without Labels or Alt Key Activation, All Supported Versions of Microsoft Excel
Shortcut Key | Control | Description |
---|---|---|
Ctrl+Plus key | Equivalent to pressing the More button in the Define Assumption or Define Forecast dialog | Displays all settings in the dialog, basic and advanced (or preferences) |
Ctrl+Minus key (hyphen or dash) | Equivalent to pressing the Less button in the Define Assumption or Define Forecast dialog | Hides advanced settings (or preferences) while displaying the basic settings |
Alt+[ | Minimum truncation grabber (text box), Define Assumption dialog | Truncates the distribution at the low end of the value range and sets the value in the Minimum text box |
Alt+] | Maximum truncation grabber (text box), Define Assumption dialog | Truncates the distribution at the high end of the value range and sets the value in the Maximum text box |
Ctrl+Up arrow, Ctrl+Down arrow | Series list box in charts; other similar list boxes | Moves up and down through the list box so a series can be selected from the list |
Ctrl+n | Methods panel, Predictor wizard | Selects or clears the Non-seasonal Methods group |
Ctrl+s | Methods panel, Predictor wizard | Selects or clears the Seasonal Methods group |
Ctrl+a | Methods panel, Predictor wizard | Selects or clears the ARIMA group |
Ctrl+m | Methods panel, Predictor wizard | Selects or clears the Multiple Linear Regression group |
Ctrl+p | Predictor Results window charts | Shows and hides confidence interval lines |
Ctrl+w, Ctrl+Shift+w | Warning footnotes in the Predictor Data Screening and Results windows | Enables screen readers to read warning footnotes if present |
Ctrl+z | Zoom control in Predictor charts | Activates and inactivates the zoom control for enlarging and reducing Predictor chart display |