The left side of the dialog box will change to the image shown in Figure 4.On the leftmost scrollable list (headed by Choose commands from), click on the downward arrow (initially next to the label Popular Commands) and choose the Add-Ins Tab option A dialog box will appear as shown in Figure 3.In the menu that appears, click on the Customize Quick Access Toolbar ….First, you need to add an icon to the QAT, as follows: In Excel 2007, 2010, 2013, 20 you can also access the Real Statistics data analysis tools via the Quick Access Toolbar (QAT), which is shown in the upper left-hand corner of Figure 1 of Excel User Interface. Press Ctrl-m and choose the Restore Real Statistics on Add-Ins Ribbon option.To do this press the Alt-F8 key sequence, enter the RSRibbon macro name (on the Macro dialog box) and press the Run button. You now have the following three new approaches when Real Statistics disappears from the Add-Ins ribbon (or more commonly when the Add-Ins ribbon itself disappears):
If Real Statistics disappears from the Add-Ins ribbon, or more commonly when the Add-Ins ribbon itself disappears, you can take any one of the following actions: This will display the same dialog box as shown in Figure 1.įigure 2 – Accessing data analysis tools via the Add-Ins ribbon To access these tools, select Add-Ins > Menu Commands|Real Statistics > Data Analysis Tools as shown in the upper left-hand side of Figure 2. When you install the Real Statistics Resource Pack on your computer, a menu item is added to Excel’s Add-Ins ribbon that provides access to the Real Statistics data analysis tools. To enable Ctrl-m, repeat the same sequence of steps except that you need to insert EnableToolsShortcut as the macro name. Next insert the macro name DisableToolsShortcut in the Macro dialog box that appears and press the Run button. To disable Ctrl-m, press Alt-F8 (or select View > Macros|Macros). In this case, you will need to use choose Real Statistics Data Analysis Tools from the Add-Ins ribbon to display this dialog box. This is the easiest approach since it can be done in all versions of Excel (Windows and Mac) no matter which Excel ribbon is active.įigure 1 – Data analysis tools dialog box (main menu)įor those of you who use the keyboard shortcut Ctrl-m for some other purpose, you can disable Crtl-m from being used as a way to display the dialog box for Real Statistics data analysis tools. You can access the dialog box which lets you choose one of the Real Statistics data analysis tools by pressing Ctrl-m.
The first approach is also available for the Mac.
On this webpage, we present a number of ways for accessing the Real Statistics data analysis tools in the Windows environment.
0 kommentar(er)
