HDTutorial
EN
How to Track Changes in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Track Changes in Excel

159,912 views October 25, 2017 6:23

Watch on YouTube
ChannelTrumpExcel

Description from the creator

If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes in Excel can come in handy.

You can also use it when you're updating a file and need to keep a track of all the changes you do yourself. This can be helpful when you revisit it sometime later.

In this video, I will show you how to track changes in Excel.

The video first covers how to enable the track changes functionality in Excel.

To do this:
-- Go to the Review tab.
-- In the Changes group, click on the Track Changes option and select Highlight Changes.
-- In the Highlight Changes dialog box, check the option - 'Track changes while editing. This also shares your workbook'. You can also specify the 'When', 'Who', and 'Where' options. For this tutorial, I will go with the default settings (these options are explained later in the article).
-- Click OK.

The above steps would enable 'Track Changes' in Excel and now it will highlight any change done to the workbook.

The video also covers:
-- How to accept/reject changes.
-- How to get a list of all the changes listed in a separate tab.
-- How to disable track changes in Excel.

Read More about track changes in Excel here: trumpexcel.com/track-changes-in-excel/

Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

About this tutorial

TrumpExcel published this 6:23 video tutorial on October 25, 2017. It has been watched 159,912 times on YouTube.

Channel
TrumpExcel
Category
Education
Duration
6:23
Published
October 25, 2017
Views
159,912
Likes
662

Tags

Share

Further reading

  • How to Enable and Use Track Changes in Excel trumpexcel.com

    Disabling Track Changes in Excel. Once your work is finalized, you can disable the track changes feature in Excel. That will remove any existing blue box in the cells and will stop tracking any further changes. Here are…

  • How to Use Track Changes in Excel - Lifewire lifewire.com

    When you use the legacy track changes feature in Excel, you'll see who made changes to the worksheet or workbook, and the changes they made. After your team finishes the review, compare your original data with the revie…

  • How to Track Changes in Excel (Step by Step with Examples) wallstreetmojo.com

    Tracking changes in excel is a technique which is used to highlight a changes done by any user in a excel shared workbook, it highlights the cell which has been changed in to a different color, this option can be enable…

This tutorial in other languages