You can then copy any of these back to your worksheet, as desired, and delete the added worksheet when you are done with it. When you click on OK, Excel creates a new worksheet that contains all the stats (and more) that might be displayed in the Task Bar. Then, near the bottom of the dialog box click the Summary Statistics check box. If the cells you want to analyze aren't already noted in the Input Range box, click once in that box and then select the cells in the worksheet. Excel then displays the Descriptive Statistics dialog box. You want to select the Descriptive Statistics option and then click OK. This dialog box does nothing except list a ton of different analyses that you can perform.
Excel displays the Data Analysis dialog box. Now, display the Data tab of the ribbon and click the Data Analysis tool. You should see your stats on the Task Bar, as normal. With the Data Analysis add-in activated, select the cells you want to analyze. Select the check box next to Analysis ToolPak.At the bottom of the dialog box use the Manage drop-down list to select Excel Add-ins.At the left side of the dialog box click Add-Ins.In Excel 2010 and later versions display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options.
This tool is implemented through the use of an add-in you can tell if it is enabled on your system by looking at the Data tab of the ribbon where you should see a Data Analysis tool at the right side. (Who said you can't shoot a gnat with a bazooka in Excel?) This approach involves the use of the Data Analysis tool. The first workaround doesn't involve using a macro, but you might consider it a bit of overkill. That being said, there are a couple of approaches that you can use to recreate the information so that you can access it. The short answer is no, there is no way to access the information in the Task Bar. Michael wonders if there is a way to copy a value from the Task Bar into the Clipboard so that he can paste that value elsewhere in the worksheet. Michael can select some cells in a worksheet and the Task Bar (at the bottom of the worksheet) shows some analysis of those selected cells-things like the sum or average of the cells.