Comparite - Comparing data

Forum home » Topics » Comparite - Comparing data

Comparite - Comparing data

Comparite is a term used mainly in the legal profession for comparing either documents or data in spreadsheets.

In Excel, data in worksheets can be compared by using the View ribbon in version 2007 or 2010. First, open the workbook and select the sheet you wish to compare. Then click New Window, then click View Side by Side. Use the Arrange All button to change from say vertical to horizontal.

In the second window choose which sheet you wish to use for comparison purposes and have a wonderful time scrolling all over to make those comparisons you so desperately need to get done! Don't forget, synchronous scrolling is switched on by default and can be turned off if required.

Once you are done, close the second window and you are ready for the next time you need to do this!

Related forum posts:

Advanced formating

How do we copare data

Read forum post



Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.07 secs.