excel training class - compare and merge excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Compare and merge Excel documents

excel training class - Compare and merge Excel documents

resolvedResolved · Low Priority · Version Standard

Melissa has attended:
Excel Introduction course

Compare and merge Excel documents

Is there any way to compare two saved Excel spreadsheets, showing the changes as mark-ups?

RE: Compare and merge Excel documents

If you are referring to Word style markups, probably not.
You could use comments, which would involve manually inserting them as you go.

alternatively if it is numerical data you are comparing, you could make a thrid sheet that tracks the difference between the two sheets, and provides you with a result. You would need to know about formulas across multiple sheets.

Hope that helps.

Richard

 

Training courses

 

Training information:

See also:

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 1.3 secs.