Advanced Microsoft Excel
Part 25 - Inquire
You can use Inquire to −
- Compare two Workbooks
- Analyze a Workbook for problems or inconsistencies
- See the links between the Workbooks
- See the links between the Worksheets
- See the Relationships between the cells
- Clean Excess Cell Formatting
- Manage Passwords
![Inquire Tab](https://www.tutorialspoint.com/advanced_excel/images/inquire_tab.jpg)
Ensure Inquire Add-in is Active
Step 1 − Click on the File tab. Click on Options.Step 2 − In the Excel Options window, click on Add-Ins. If Inquire Add-in is Active, then it will appear under Active Application Add-ins.
![Active Application Add-ins](https://www.tutorialspoint.com/advanced_excel/images/active_application_addins.jpg)
Step 3 − Click on the File tab. Click on Options.
Step 4 − In the Excel Options Window, click on Add-Ins.
Step 5 − In the Manage Box, Click on COM Add-ins.
![COM Add-ins](https://www.tutorialspoint.com/advanced_excel/images/com_add_ins.jpg)
Step 7 − Select Inquire and then click OK.
![COM Add-ins Inquire](https://www.tutorialspoint.com/advanced_excel/images/com_add_ins_inquire.jpg)
Compare Two Workbooks
You can compare two workbooks cell by cell and see the differences, if any.Step 1 − Open two Workbooks.
Step 2 − Click on the INQUIRE tab on the ribbon.
![Inquire Tab](https://www.tutorialspoint.com/advanced_excel/images/inquire_tab_on_ribbon.jpg)
![Compare Files](https://www.tutorialspoint.com/advanced_excel/images/compare_files.jpg)
Step 5 − If the file name displayed is not the one you wanted, click on the down-arrow next to the File name. Only the Workbooks that are open will be displayed.
![Down-arrow Open Workbook](https://www.tutorialspoint.com/advanced_excel/images/down_arrow_open_workbook.jpg)
Step 7 − Check the order of the Files in Compare and To.
![Compare Two Files](https://www.tutorialspoint.com/advanced_excel/images/compare_two_files.jpg)
![Swap Files](https://www.tutorialspoint.com/advanced_excel/images/swap_files.jpg)
The results of the comparison appear in a two-pane grid. The Workbook on the left corresponds to the "Compare" file you chose and the Workbook on the right corresponds to the "To" file. The details appear in a pane below the two grids. The changes are highlighted by color, depending on the kind of change. The legend that shows what the colors mean is in the lower-left pane.
![Workbook Compare](https://www.tutorialspoint.com/advanced_excel/images/workbook_compare.jpg)
![Resize Cells](https://www.tutorialspoint.com/advanced_excel/images/resize_cells.jpg)
![Export Group](https://www.tutorialspoint.com/advanced_excel/images/export_group.jpg)
![Save As Dialog Box](https://www.tutorialspoint.com/advanced_excel/images/save_as_dialog_box.jpg)
If you need the results in another program, you can do it by copying it to the Clipboard.
Step 12 − Click on Copy Results to Clipboard in the Export group.
![Copy Results to Clipboard](https://www.tutorialspoint.com/advanced_excel/images/copy_results_to_clipboard.jpg)
No comments:
Post a Comment