IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
Using Extended View mode in the Comparison Report
xlCompare has unique feature which greately simplifies your work with comparison results. It help to see the actual change in-place. This screenshot shows Extended View feature in the action:
Every updated cell (has yellow background) displays 2 values: original value and updated value from another worksheet.
2 arrows (down and up) indicates that value is shown in the Extended View mode.
Why we suggest you to use this view? When you see updated value you should not search for a corresponding one on the another worksheet. In one cell you see both values. It is handy and easy to use approach.
How to enable this mode?
View | Options | Extended View menu command and appropriate button on the menu bar (in the red square on the screenshot below) enables or disables this mode. You can change the option when you have the comparison results on the screen.
This option is stored and on the next run xlCompare will use previous value.