Important: Spreadsheet Compare is only available with Office Professional Plus 2013 or Office 365 ProPlus.Open Spreadsheet Compare.In the lower-left pane, choose the options you want included in the workbook comparison, such as formulas, cell formatting, or macros. Or, just Select All.On the Home tab, choose Compare Files.In the Compare Files dialog box, in the Compare row, browseto the earlier version of your workbook. In addition to files saved on your computer or on a network, you can enter a web address to a site where your workbooks are saved.In the Compare Files dialog box, in the To row, browseto the version you want to compare that earlier version against. Note: If you get an 'Unable to open workbook' message, this might mean a workbook is password protected. Click OK and then enter the password.
![](/uploads/1/2/6/3/126345726/835375719.jpg)
Compare 2 files free download - Compare It, Files Compare Tool, Compare Two Text Files By Line Software, and many more programs. Inspired by the accepted answer above, I found a very comfortable way how you can instantly compare two files with Visual Studio by using drag and drop or via the 'Send To' context menu. It only requires a little preparation which you need to do once and then it is useful like a Swiss army knife.
Learn more about.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. Details appear in a pane below the two grids.
Changes are highlighted by color, depending on the kind of change.Understanding the results.In the side-by-side grid, a worksheet for each file is compared to the worksheet in the other file, beginning with the leftmost worksheet in each. If a worksheet is hidden in a workbook, it's still shown and compared in Spreadsheet Compare.If the cells are too narrow to show the cell contents, click Resize Cells to Fit.Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with 'entered values' (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list. The lower-left pane is a legend that shows what the colors mean.Other ways to work with the comparison resultsIf you want to save your results or analyze them elsewhere, you can export them to an Excel file or copy and paste them into in another program, such as Microsoft Word.
There's also an option for getting a high-fidelity look at each worksheet that shows the cell formatting, close to what you'd see it in Excel.You can export the results to an easier to read Excel file. Click Home Export Results.Click Home Copy Results to Clipboard to copy and paste the results to another program.To show cell formatting from the workbook, click Home Show Workbook Colors.Other reasons to compare workbooks.Say your organization is due to be audited. You need a trail for your critical workbooks that shows the changes month over month or year over year. This trail can help you find and correct mistakes before the auditors find them.In addition to comparing contents of worksheets, you can use Spreadsheet Compare to check for differences in VBA (Visual Basic for Applications) code. The results are returned in a window in which you can see the differences side by side.
Free to Try
Windows
2.4 MB
9,263
EditPlus supports powerful and customizable syntax highlighting for HTML, CSS, PHP, ASP, Perl, C/C++, Java, JavaScript and VBScript by default. Also, you can create your own syntax file to support other programming languages.
Internet features
- Seamless web browser for previewing the content of your HTML document or Java applet without leaving the editor. Browser window also has common browser commands so you can browse Internet web sites as well as local HTML files.
- FTP commands for uploading your local files to FTP server or for editing remote files directly.
- Highlights URL and e-mail addresses in normal text files and lets you activate them with a single keystroke (F8) or 'Ctrl + double-click'.
Hex Viewer
![Plus Plus](http://www.technicaloverload.com/wp-content/uploads/2012/06/compare-results.png)
The Hex Viewer allows you to display current file in Hex mode. You can switch back and forth between normal editing window and the Hex Viewer with one command.
Code Folding
EditPlus supports fast and convenient code folding feature based on line indentation. You can hide or disply lines of code with its indent levels.
HTML toolbar
The HTML Toolbar allows you to insert common HTML tags quickly and easily. It also supports useful tools such as HTML Color Picker, Character Picker, Table Generator and Object Picker.
Document selector
The Document Selector offers quick mouse access to all document windows currently loaded. Much faster than selecting on Window menu or pressing Ctrl+Tab key multiple times.
User tools
EditPlus supports user-defined tools, help files and keystroke recording files. The output of tool execution can be captured in the Output Window, so that you can double-click the error line to automatically load the file and locate the cursor to that line.
Auto completion
Auto completion is a time-saving feature which changes a short abbreviation into a complete string. It supports Perl and C/C++ by default. Also, you can create your own auto completion file to support other programming languages.
Cliptext window
The cliptext window is collection of text clips for quick and easy access. You can easily customize them, and you can also create your own cliptext file.
Document template
Document template offers a quick start when you create a new document.
Other features
Line number, ruler, column selection, powerful search and replace, multiple undo/redo, spell checker, customizable keyboard shortcuts, and more.
What's New:
Features
- Adds 'Modifying a tag automatically updates the matching tag' option ('Preferences'->'General').
- Improves speed for large column selection.
- Adds 'Notify end of file' option in the Find dialog box.
- Adds 'Edit'->'Others'->'Reverse Lines' menu command.
Bug fixes
- Fixes an issue where some FTPS servers could cause program crash.
- Fixes an issue where FTPS could fail to download file and show empty content.
- Fixes an issue where 'View in Browser' command on remote file could cause program crash.
- Fixes an issue where 'Shell Open' a folder could unintentionally run exe of the same name.
- Fixes an issue where creating a new remote file from directory window could produce error message.
- Fixes an issue where Open Remote dialog box loses focus after transferring a file.
- Fixes an issue where Save As Remote dialog box could have wrong initial value for Encoding option.
- Fixes an issue where 'Hex Viewer' command on remote files could cause program crash.
- Fixes an issue where 'Capture Output' option didn't work with 64-bit console apps.
- Fixes an issue where function list could have wrong selection if document view was split.
- Fixes an issue where User Toolbar position could be restored incorrectly between sessions.
- Fixes an issue where Find box in the function list couldn't handle ctrl+backspace and ctrl+delete.
- Fixes an issue where Directory Window couldn't handle FTP Group 11 and above.
- Fixes an issue where undoing forward delete could result in wrong cursor position.
- Fixes an issue where 'Use regex' option in the 'Advanced' file extensions dialog box didn't work.
Apps similar to EditPlus Text Editor 5
-
239 votesFree source code editor which supports several programming languages running under the MS Windows environment.
- Freeware
- Windows
-
18 votesEvernote is a free note-taking application for Windows, Mac, Android, iOS, WP, and BB with cross platform support.
- Freeware
- Windows/macOS/Android/iOS
-
8 votesA free, lightweight and user-friendly note taking application.
- Freeware
- Windows
![](/uploads/1/2/6/3/126345726/835375719.jpg)