Starting the application<\/h2>\n
To run the tool go to:<\/p>\n
- \n
- Windows 7<\/strong> – Start > All programs\u00a0> Microsoft Office > Office Tools 2013 > Spreadsheet Compare<\/li>\n
- Windows 8<\/strong> – Start (Metro) > type\u00a0Spreadsheet Compare and\u00a0an icon will appear to run it<\/li>\n<\/ul>\n
What does it do?<\/h2>\n
We have two files before and after changes. Some data has changed, shifted, changed the format etc. We wonder to what exactly changes occurred, we do not control everything manually. For our example, the figures show two files with a small table, which is initially in the original\u00a0form and the\u00a0second table is modified. In the Spreadsheet Compare we select Compare Files icon, select two files that we compare. Both files must have the extension .xlsx since\u00a0version 2007 or later.<\/p>\n
After loading both sources\u00a0the tool displays the differences in the table at the bottom, both textual summary and color according to the type of difference – whether it is the difference in value, size, etc. Additionally, you can alsi see a chart with the number of individual differences. At the bottom left is possible by checking the appropriate option to view only those differences that we are interested in at the moment.<\/p>\n
Using tab up we\u00a0can easily view both tables and formatting with an icon Show Workbook Formatting and adjust the size of the content inside the cell through the Resize Cells to Fit. Results comparing the differences can be exported to a new workbook by choice Export Results and can\u00a0be sent to your colleagues.<\/p>\n
- Windows 8<\/strong> – Start (Metro) > type\u00a0Spreadsheet Compare and\u00a0an icon will appear to run it<\/li>\n<\/ul>\n
![\"\"](https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/spreadsheet_compare1.jpg "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t