[Solved]: Track Changes Not Showing in Excel (with Easy Fix)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we need to use the Track Changes option in Excel. But we must enable it first. In this article, I will discuss a solution that you can use for the problem track changes in Excel not showing.


6 Steps to Solve Track Changes Not Showing Problem in Excel

Track Changes is a useful tool in Excel when you want your worksheet to be reviewed by or shared with others. It also comes in handy if you want to track all the changes that you have made in the workbook. Normally you do not see the Track Changes option in the Review tab.

track changes in excel not showing

So let’s see the steps to enable Track Changes in Excel.


Step 1: Customize Ribbon to Bring Excel Options

  • Go to the Review Tab.
  • Then call the Customize the Ribbon option by right-clicking your mouse. After that, select it.


Step 2: Create a New Group from Excel Options

  • Excel Options box will appear. Select New Group.

track changes in excel not showing


Step 3: Rename the New Group

  • Now, you have to rename the newly created group. For this, select Rename.

  • Then type the display name. I have given the name Track Changes.

track changes in excel not showing


Step 4: Choose All Commands from Drop-Down Box

  • After that, select All Commands from the drop-down box (see the image below).


Step 5: Add Track Changes from All Commands

  • Now, you have to enable the track changes. For this, select Track Changes (Legacy) from the list of the commands and then Add.

track changes in excel not showing


Step 6: Enable Track Changes to Complete the Task

  • Now, click OK and complete the process.

  • You will see that Excel has enabled the Track Changes option.

track changes in excel not showing

Read More: Excel VBA: Track If a Cell Value Changes


Things to Remember

  • Track Changes are not available by default.
  • You can use Co-Authoring as a replacement for Track Changes.

Conclusion

In this article, I have shown an easy way to enable Track Changes. I hope it helps everyone. If you have any kind of suggestions, ideas, or feedback, please feel free to comment down below.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo