You can also share your Excel file using a local network drive, which is the 'old' method but might be ideal for people in a physical office setting. First Things Firstīefore collaborating, we must know how to share our workbook using Microsoft Online. This article will walk you through how to use the new Show Changes feature step-by-step. But let's face it, Leila Gharani said best in her video, 'you like the idea of collaboration, but you don't like the idea of sharing your files.'Ĭollaboration is inevitable, so that's why having the ability to track changes while editing, accept or reject changes, restore previous cell content, and much more while under the watchful eye of multiple reviewers. It's no secret that since the advent of Google Sheets, Microsoft Excel users have been itching for the same collaborative experiences as Excel's free-to-use counterpart offers. Knowing that their changes are tracked in the workbook down to the cell level via any editing point, whether on a desktop, Mac, iPad, iOS, or Android. While showing changes, you can now be confident in sharing your workbooks with others.

Show changes are an essential step in the collaboration experience in Excel. There are some points to remember about the tracking features in Excel: You can quickly review all changes directly in the worksheet and accept or reject changes in Excel. You may want to track when the change was made, who made the change, what cell the change occurred in, and what data was changed.Įxcel has tracking features built-in that can handle all the above cases. There are several situations where you must distribute a file to multiple people and keep track of the changes created by other users.

This, on its own, is a huge deal! Imagine having a spreadsheet made and wanting to have your colleague go over or audit your workbook to check for any errors. Unbeknownst to many Excel users, Excel, like its Word counterpart, also allows you to track changes while editing. So what makes this feature so exciting? Why Having Track Changes and Show Changes is a Big Deal This popular feature on Microsoft Word, used primarily for collaborating and making edits, is now available through your Microsoft 365 subscription* (they do not have a date when it will be available on Desktop).

Show Changes, which allows users to track changes made to their spreadsheet. Earlier this month via Twitter, Excel announced what will be a game-changing feature.

Latest version of excel 2021