Collaborate with confidence: Introducing Show Changes for Excel on the Web

Published 04-29-2021 08:50 AM 21.2K Views
Microsoft

We’re excited to announce a new feature in Excel for the web called Show Changes.  Show Changes in Excel revolutionizes the collaboration experience for one main reason: if you pour days and detail into the perfect Excel workbook, you may hesitate before sharing editing permissions with others.  And you can’t have collaboration without sharing.  Now, with Show Changes, you have the “safety net” of knowing that any changes done by others are being tracked for the entire workbook down to a single cell.   

 

 

The Show Changes feature enables you to collaborate confidently with others by letting you see exactly what edits were made to your workbooks up to 60 days. You can see details about who changed what, where, and when, along with the previous value of the cell for quick reversion, if needed.   

 

 

So if someone accidentally overwrites your formula, you can easily catch it and fix it.  You can even see bulk edits – edits made to a whole row or range of cells at the same time – within a card in the Show Changes pane. 

 

You can also narrow down the list of changes.  If you want to see changes made JUST to a specific sheet, or range, or even an individual cell, you can select the area you want to investigate.  Then, just right-click and you’ll see the Show Changes option there.   

 

 

You can get started with Show Changes in Excel for the web today by accessing your Microsoft 365 subscription using your favorite operating system and device. With support for Windows, Mac, iPads and iPhones, and Android phones and tablets, you can be assured that all of your team's changes will be tracked. So why not take the leap and go for it? Share those workbooks and try out Show Changes in Excel for the web today.

 

Have feedback on Show Changes?  Send us a smile or frown.  Also, subscribe to our Excel Blog to get the latest product updates and announcements, and join our Excel Community to stay connected with us and other Excel fans around the world.

 

2 Comments
Occasional Visitor

Hi there, this looks really useful and another point off the list where google sheet used to be better .

I am wondering if this experience coming to Excel Desktop as well?

And will it also show structural changes? Do you have plans for "smarter" changes? E.g. when I cut and paset something it can either be shown as a deletion and an edit or as a cut/paste operaton?

 

Looking forward to seeing this feature develop in the future.

Senior Member

Is that feature supposed to be available on Excel Desktop? The article mentions support for Windows, Mac, iPads and iPhones, and Android phones and tablets. Changes made from desktop versions are tracked correctly but I only see the button to see changes on Excel Online.

%3CLINGO-SUB%20id%3D%22lingo-sub-2318429%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318429%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20that%20feature%20supposed%20to%20be%20available%20on%20Excel%20Desktop%3F%20The%20article%20mentions%20support%20for%26nbsp%3B%3CSPAN%3EWindows%2C%20Mac%2C%20iPads%20and%20iPhones%2C%20and%20Android%20phones%20and%20tablets.%20Changes%20made%20from%20desktop%20versions%20are%20tracked%20correctly%26nbsp%3Bbut%20I%20only%20see%20the%20button%20to%20see%20changes%20on%20Excel%20Online.%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279187%22%20slang%3D%22en-US%22%3ECollaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279187%22%20slang%3D%22en-US%22%3E%3CP%3EWe%E2%80%99re%20excited%20to%20announce%20a%20new%20feature%20in%20Excel%20for%20the%20web%26nbsp%3Bcalled%26nbsp%3BShow%20Changes.%26nbsp%3B%26nbsp%3BShow%20Changes%20in%20Excel%20revolutionizes%20the%20collaboration%20experience%20for%20one%20main%20reason%3A%20if%20you%20pour%20days%20and%20detail%20into%20the%20perfect%20Excel%20workbook%2C%20you%20may%20hesitate%20before%20sharing%20editing%20permissions%20with%20others.%26nbsp%3B%26nbsp%3BAnd%20you%20can%E2%80%99t%20have%20collaboration%20without%20sharing.%26nbsp%3B%26nbsp%3BNow%2C%20with%20Show%20Changes%2C%20you%20have%20the%20%E2%80%9Csafety%20net%E2%80%9D%20of%20knowing%20that%20any%20changes%26nbsp%3Bdone%26nbsp%3Bby%20others%20are%20being%20tracked%20for%20the%20entire%20workbook%20down%20to%20a%20single%20cell.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%26nbsp%3BShow%20Changes%26nbsp%3Bfeature%26nbsp%3Benables%20you%20to%20collaborate%20confidently%20with%20others%26nbsp%3Bby%20letting%26nbsp%3Byou%20see%20exactly%20what%20edits%20were%20made%20to%20your%26nbsp%3Bworkbooks%26nbsp%3Bup%20to%26nbsp%3B60%20days.%20You%20can%20see%20details%26nbsp%3Babout%26nbsp%3Bwho%20changed%20what%2C%20where%2C%20and%20when%2C%20along%20with%20the%20previous%20value%20of%20the%20cell%20for%20quick%20reversion%2C%20if%20needed.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%26nbsp%3Bif%20someone%20accidentally%20overwrites%26nbsp%3Byour%26nbsp%3Bformula%2C%20you%20can%20easily%20catch%20it%20and%20fix%20it.%26nbsp%3B%20You%20can%20even%20see%20bulk%20edits%20%E2%80%93%20edits%20made%20to%20a%20whole%20row%20or%20range%20of%20cells%20at%20the%20same%20time%20%E2%80%93%20within%20a%20card%20in%20the%20Show%20Changes%20pane.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%26nbsp%3Balso%26nbsp%3Bnarrow%20down%20the%20list%20of%20changes.%26nbsp%3B%26nbsp%3BIf%20you%20want%20to%20see%20changes%20made%20JUST%20to%20a%20specific%26nbsp%3Bsheet%2C%26nbsp%3Bor%26nbsp%3Brange%2C%20or%26nbsp%3Beven%20an%26nbsp%3Bindividual%20cell%2C%26nbsp%3Byou%20can%20select%20the%20area%20you%20want%20to%20investigate.%26nbsp%3B%26nbsp%3BThen%2C%20just%20right-click%20and%20you%E2%80%99ll%20see%20the%20Show%20Changes%20option%20there.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20get%20started%20with%20Show%20Changes%20in%20Excel%20for%20the%20web%20today%20by%20accessing%20your%20Microsoft%20365%20subscription%20using%20your%20favorite%20operating%20system%20and%20device.%20With%20support%20for%20Windows%2C%20Mac%2C%20iPads%20and%20iPhones%2C%20and%20Android%20phones%20and%20tablets%2C%20you%20can%20be%20assured%20that%26nbsp%3Ball%20of%26nbsp%3Byour%20team's%20changes%20will%20be%20tracked.%20So%20why%20not%20take%20the%20leap%20and%20go%20for%20it%3F%20Share%20those%20workbooks%20and%20try%20out%20Show%20Changes%20in%20Excel%20for%20the%20web%20today.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20feedback%20on%20Show%20Changes%3F%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3ESend%20us%20a%20smile%20or%20frown%3C%2FA%3E.%26nbsp%3B%20Also%2C%20subscribe%20to%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%20Blog%3C%2FA%3E%26nbsp%3Bto%20get%20the%20latest%20product%20updates%20and%20announcements%2C%20and%20join%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%20Community%3C%2FA%3E%26nbsp%3Bto%20stay%20connected%20with%20us%20and%20other%20Excel%20fans%20around%20the%20world.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2279187%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3EShow%20Changes%20revolutionizes%20the%20collaboration%20experience%20in%20Excel%20for%20the%20web%2C%20tracking%20edits%20at%20the%20cell%20level.%20%26nbsp%3B%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2308302%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20this%20looks%20really%20useful%20and%20another%20point%20off%20the%20list%20where%20google%20sheet%20used%20to%20be%20better%20.%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20this%20experience%20coming%20to%20Excel%20Desktop%20as%20well%3F%3C%2FP%3E%3CP%3EAnd%20will%20it%20also%20show%20structural%20changes%3F%20Do%20you%20have%20plans%20for%20%22smarter%22%20changes%3F%20E.g.%20when%20I%20cut%20and%20paset%20something%20it%20can%20either%20be%20shown%20as%20a%20deletion%20and%20an%20edit%20or%20as%20a%20cut%2Fpaste%20operaton%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20forward%20to%20seeing%20this%20feature%20develop%20in%20the%20future.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Apr 28 2021 09:31 AM
Updated by: