98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |