With the latest update, Excel users will be able to access a log of changes that tracks which elements of a spreadsheet have been edited, by whom and when. The data can be filtered by sheet, range or individual cell and extends as far back as 60 days.
Microsoft Excel will also save a copy of the previous cell value after a change is made, making it easy to reverse data entry errors and recover from larger mistakes that would otherwise have required lengthy remediation.
- Check out our list of the best productivity software available
- Here's our list of the best collaboration software out there
- We've built a list of the best office software on the market
Microsoft Excel update
According to Microsoft, the “Show Changes” feature has been among the most frequently requested for some time, with customers looking for a way to rectify blunders more easily.
A similar function is already available in rival service Google Sheets, so the Excel update will restore parity between the two tools in this respect. In Sheets, right-clicking on a cell and selecting “Edit History” allows users to scroll through previous cell values via simple backwards and forwards arrows.
In a blog post, Microsoft claims the Excel update will encourage greater collaboration by eliminating some of the risk associated with sharing editing permissions with a large number of users.
“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,” wrote Sanjay Bhat, Senior Program Manager at Microsoft.
“Now, with Show Changes, you have a ‘safety net’ of knowing that any changes done by others are being tracked for the entire workbook down to a single cell.”
The new feature is available immediately via the Excel web client across all popular operating systems, including Windows 10, macOS, iOS and Android. Microsoft has not yet responded to questions from TechRadar Pro surrounding if and when the feature might be integrated into Excel for desktop.
- Here's our list of the best accounting software around
Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
Joel Khalili is the News and Features Editor at TechRadar Pro, covering cybersecurity, data privacy, cloud, AI, blockchain, internet infrastructure, 5G, data storage and computing. He's responsible for curating our news content, as well as commissioning and producing features on the technologies that are transforming the way the world does business.