Excel compare documents freeware

Clash of Clans. Subway Surfers. TubeMate 3. Google Play. Microsoft is done with Xbox One. N95, KN95, KF94 face masks. Apple pulls Wordle clones. Windows Windows. Most Popular. New Releases. Desktop Enhancements. Networking Software. Trending from CNET. Download Now. Developer's Description By Formula Software.

Excel Compare is a tool that saves you the trouble of manually searching for differences and offers you computer-aided comparing of Excel files. Because those values changed, the calculated results in the YTD column also changed — cells F2:F4 and E6:F6 have a blue-green fill that means the calculated value changed. The calculated result in cell F5 also changed, but the more important reason is that in the earlier version its formula was incorrect it summed only B5:D5, omitting the value for Q4.

If the cells are too narrow to show the cell contents, click Resize Cells to Fit. In addition to the comparison features of Spreadsheet Compare, Excel has an Inquire add-in you can turn on that makes an "Inquire" tab available.

From the Inquire tab, you can analyze a workbook, see relationships between cells, worksheets, and other workbooks, and clean excess formatting from a worksheet. If you have two workbooks open in Excel that you want to compare, you can run Spreadsheet Compare by using the Compare Files command.

If you don't see the Inquire tab in Excel, see Turn on the Inquire add-in. To learn more about the tools in the Inquire add-in, see What you can do with Spreadsheet Inquire. Microsoft Audit and Control Management Server provides powerful change management features for Excel and Access files, and is complemented by Microsoft Discovery and Risk Assessment Server, which provides inventory and analysis features, all aimed at helping you reduce the risk associated with using tools developed by end users in Excel and Access.

Also see Overview of Spreadsheet Compare. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Open two Excel documents. Click the View tab.

Click View Side by Side. Click Arrange All to adjust display. Enable Synchronous Scrolling. Did this summary help you? Yes No. Log in Social login does not work in incognito and private browsers.

Please log in with your username or email to continue. No account yet? Create an account. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy. Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article methods.

Tips and Warnings. Related Articles. Article Summary. Method 1. Open the workbooks you need to compare. You can find these by opening Excel, clicking File then Open , and selecting two workbooks to compare from the menu that appears. Navigate to the folder where you have the Excel workbooks saved, select each workbook separately, and keep both workbooks open. Once you've opened one of the workbooks, you can click on the View tab in the top-center of the window.

This is located in the Window group of the ribbon for the View menu and has two sheets as its icon. This will pull up both worksheets into smaller windows stacked vertically. This option may not be readily visible under the View tab if you only have one workbook open in Excel. If there are two workbooks open, then Excel will automatically choose these as the documents to view side by side.

Click Arrange All. This setting lets you change the orientation of the workbooks when they're displayed side-by-side. In the menu that pops up, you can select to have the workbooks Horizontal , Vertical , Cascade , or Tiled.

Once you have both worksheets open, click on Synchronous Scrolling located under the View Side by Side option to make it easier to scroll through both Excel files line-by-line to check for any differences in data manually. Scroll through one workbook to scroll through both. Once Synchronous Scrolling is enabled, you'll be able to easily scroll through both workbooks at the same time and compare their data more easily.

Method 2. Navigate to the folder where you have the Excel workbooks saved, select each workbook separately and keep both workbooks open. Decide on which cell you would like the user to select from. This is where a drop-down list will appear later.