Inquire Tab In Excel 13
Posted by officesmart
What happens when we want to compare versions of a workbook, or analyze a workbook or even see links between workbooks or worksheets? That is where the Inquire tab comes in.
In order to use the Inquire tab we need to activate it first and we must be using Office Professional Plus. Have a look at my post How To Activate Add-Ins in order to activate the Inquire Add-In.
The Inquire tab is separated in the following areas on the ribbon:
Report: Workbook Analysis
Diagram: Workbook Relationship – Worksheet Relationship – Cell Relationship
Compare: Compare Files
Miscellaneous: Clean Excess Cell Formatting – Workbook Passwords – Help
The Workbook Analysis command creates an interactive report that shows detailed information about the workbook. It displays its structure, formulas, cells, ranges, warnings. If we press the Workbook Analysis command, which is located in the Report area of the ribbon, a warning Workbook Analysis window appears, which notifies us that Only Changes That Have Been Saved Will Be Included In This Analysis. We have the option to Save our changes or not as shown in the image below.
Once we have selected Yes or No the Worksheet Analysis Report window appears as shown in the image below.
In this window, under the area Items we can select what we want to be displayed, by simply clicking on the checkboxes at the left of the Items, as we can see in the image below. Once we have selected the Items that we want, at the right of the window and under the area, Results all the results are displayed. At the bottom left corner of the Workbook Analysis Report, we can press the Excel Export button as shown below in order to Export the Workbook Analysis Report, to view the Analysis better.
Once we select the Excel Export button a new button appears at the right of the command which is named Load Export File as we can see below.
Once we select the Load Export File button a new Excel Workbook appears with all the Analysis Report as we can see in the image below, in order to view the report more detailed.
In the area of the ribbon named Diagram, we can select the Workbook Relationship command in order to create an interactive, graphical map of workbooks that depend on each other. In the image below I have selected the Workbook Relationship command, but because the particular workbook doesn’t has any relationships with other workbooks we only see the specific workbook. Otherwise, if it had connections with other workbooks, we would see the current workbook on the left and the connections between it and other workbooks and data sources on the right.
In the area of the ribbon named Diagram, we can select the Worksheet Relationship command in order to create an interactive, graphical map of connections between worksheets in the same workbook and in other workbooks. In the image below, I have selected the Worksheet Relationship command, and the diagram below we can see the relationships in the same workbook. This gives us a clearer image of how our data depends on cells in other worksheets.
In the area of the ribbon named Diagram, we can select the Cell Relationship command in order to create an interactive diagram of all links from a selected cell to cells in other worksheets. Once we select the Cell Relationship command, the Cell Relationship Diagram Options window appears as shown below. Here we do the adjustments that we want and then press the OK button.
Once we press OK the Cell Relationship Diagram window appears, where we can see the relationships between the cells in the workbook.
The Compare Files lets us see the differences cell by cell between two Excel Workbooks. In order for this to work, we must have two Excel workbooks open. In the image below, I have selected the Compare Files command from the Inquire ribbon and under the area Compare, and straight away the Select Files To Compare window appears as shown in the image below. Then from the right of the Compare: command we select the drop down menu in order to select the Excel workbook, and then from the right of the command To: we select the Excel workbook that we want to compare to. We can always use the Swap Files button that is located at the bottom left of the window in order for the two selected Workbooks to be swapped. Once done we just press the Compare button at the bottom right corner of the window.
Once we press the Compare button, the Status dialog box appears notifying us that it is comparing the two selected Workbooks. This might take a little bit of time.
Straight away the Spreadsheet Compare window appears, where at the top of the window we notice the names of the two selected workbooks. The results are color coded that depend on the kind of the content, such as entered values, formulas, range names and formats as we can see in the image below.
Clean Excess Cell Formatting
In the area of the ribbon named Miscellaneous of the Inquire tab we can select the command Clean Excess Cell Formatting command in order to remove excess formatting of the workbook in order for the workbook to reduce size, that causes our workbook to load slowly or has become huge. Once selected the Clean Excess Cell Formatting window appears where from the drop down menu at the right of the command Apply To we can select either for the cleaning to be applied to either All Sheets or Active Sheets as we can see in the image below. Once we select what we want, we just press the OK button and that is it.
In the area of the ribbon named Miscellaneous of the Inquire tab we can select the command Workbook Passwords where we have to add the workbook password to our password list so we can then open the save copy of our workbook. If we add passwords on our workbooks they will be saved on our computer. These passwords will be encrypted and only accessible by us.
Below you can check out the video describing the features of the Inquire tab in Excel 13.
About officesmartMVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system
Posted on July 10, 2014, in Excel English 2013, Microsoft Office 2013 English and tagged Cell Relationship Diagram Options, Compare Files, Compare: Compare Files, Diagram: Workbook Relationship – Worksheet Relationship – Cell Relationship, Excel Export, Inquire Tab, Load Export File, Microsoft Excel 13, Microsoft Office 13, Miscellaneous: Clean Excess Cell Formatting – Workbook Passwords – Help, MVP, Office Smart, Office System, Report: Workbook Analysis, Smart Office, Spreadsheet Compare. Bookmark the permalink. Comments Off on Inquire Tab In Excel 13.
Comments are closed.