Microsoft introduced Show Changes, a new feature in Excel for the web.
Show Changes in Excel transforms the collaboration experience for one simple reason: if you spend days and hours perfecting an Excel workbook, you may be hesitant to share editing permissions with others. And collaboration is impossible without sharing. You now have the “safety net” of knowing that any changes made by others are being tracked for the entire workbook down to a single cell with Show Changes.
What is Show Changes?
The Show Changes feature allows you to confidently collaborate with others by allowing you to see exactly what changes were made to your workbooks for up to 60 days.
How it works
You can see who changed what, where, and when, as well as the previous value of the cell for quick reversion if necessary. As a result, if someone accidentally overwrites your formula, you can easily detect and correct it. In the Show Changes pane, you can even see bulk edits – changes made to an entire row or range of cells at the same time – within a card.
You can also limit the number of changes. You can select the area to investigate if you only want to see changes made to a specific sheet, range, or even a single cell. Then, right-click and select the Show Changes option.
You can get started with Show Changes in Excel for the web right away by logging in to your Microsoft 365 account with your preferred operating system and device. With support for Windows, Mac, iPads, iPhones, and Android phones and tablets, you can be confident that all changes made by your team will be tracked. So why not take a risk and go for it? Share those workbooks and give Show Changes in Excel for the Web a try today.
Author: Jace Mrazz is a Microsoft Office expert with 5 years of experience in the technology industry. He has written technical blogs, white papers, and reviews for a variety of websites, including office.com/setup and microsoft365.com/setup