Mobile menu

Comparing Excel files
Thread poster: Michael Deliso

Michael Deliso  Identity Verified
Local time: 11:06
Italian to English
+ ...
Jun 24, 2005

Can someone explain to me how to compare two excel files side by side so to view and compare errors and/or differences? just like it can be done with Word..

Direct link Reply with quote
 
Prisma
English to Swedish
+ ...
2 windows in Excel Jun 24, 2005

Michael,

1. Open the two files you would like to compare in Excel.
2. From the "Window" menu in Excel, choose "Arrange..." then "vertical".

Your files will now appear side by side.

Good Luck!


Direct link Reply with quote
 

Can Altinbay  Identity Verified
Local time: 05:06
Japanese to English
+ ...
A rather indirect approach Jun 24, 2005

There's a "merge" facility in Excel, but the files have to be versions of the same file (see their Help pages for better details). I'm sure someone will come up with something more brilliant that this, but just a couple of days ago, I saved them as CSV files and put them through a diff utility. I like WinMerge, which is free from http://winmerge.sourceforge.net/. If you Google appropriately, you might find something that does Excel files directly, there used to be a Word comparison tool, but it cost money, and Word's merger worked well enough for me.

Direct link Reply with quote
 

Michael Deliso  Identity Verified
Local time: 11:06
Italian to English
+ ...
TOPIC STARTER
Comparing Excel files Jun 25, 2005

Thanks for the help..I'll try either one of them..

Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maria Castro[Call to this topic]

You can also contact site staff by submitting a support request »

Comparing Excel files

Advanced search


Translation news





PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs