how to update recent files in excel 2016

Then you will be prompted to select the range or sheet that you want to filter. To filter, just click on the button with the funnel icon.

You can filter by sheet or even by range. Filter the Change ListĪs you can imagine, the list of changes can get pretty long over time, so one of the cool features to know about is the ability to filter. Here is a help page from Microsoft that explains when changes will be tracked and some scenarios where the history might be cleared. As mentioned above, you can make changes to the file on the desktop version of Excel, then view the changes in the web version. The Show Changes pane is currently available on Excel for the web, which you will access in your web browser. The files that you want to track changes on must be stored on OneDrive or SharePoint, and you must have a Microsoft 365 subscription to use this feature. Knowing what the previous value was can be useful in case you need to change it back.Ĭlick on any of the changes in the list and it will automatically navigate to the cell where the change was made. In instances where values were updated, the entry shows what the old value was in addition to the new value. Included with each entry is the name of the person who made the change, a timestamp of when the change was made, and a description of what the change was. The list contains all of the changes that have been made in the workbook. This will open up a task pane on the right side of the worksheet that has a running list. See the changes that have been made to a workbook by going to the Review tab. While changes made on the desktop application are still tracked, to view those changes you need to be using the web version. Now you can essentially access a transcript to those changes and see who did what and when.Ĭurrently, you can only view this record of changes using Excel Online. Excel tracks all of the changes that you and your co-authors are making to a shared workbook. It's especially helpful if you have multiple people co-authoring (collaborating on) the same file. There's an awesome new feature in Excel called Show Changes.

Watch on YouTube & Subscribe to our Channel See Everyone's Changes!

How to update recent files in excel 2016