ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I compare two versions of the same spreadsheet to see diff. (https://www.excelbanter.com/excel-discussion-misc-queries/221443-how-do-i-compare-two-versions-same-spreadsheet-see-diff.html)

John C.

How do I compare two versions of the same spreadsheet to see diff.
 
When I edit a spreadsheet is there a function in excel that allows me to
compare it to the original with the changes highlighted? I can do this in
Word, but can't figure out if it can be done in excel. Thanks

Luke M

How do I compare two versions of the same spreadsheet to see diff.
 
Perhaps
Tools-Track Changes-Highlight changes
is what you're looking for?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John C." wrote:

When I edit a spreadsheet is there a function in excel that allows me to
compare it to the original with the changes highlighted? I can do this in
Word, but can't figure out if it can be done in excel. Thanks



All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com