How to track changes in Microsoft Excel

Suppose you have an Excel worksheet that you share with many people. Obviously, there will be 1000 edits, and ultimately, your job is to verify which one is a valid edit and which one is not. If you had some magical power you could use it to see who made which edits and when? Also, to make it even sweeter, you can decide whether to accept or reject the corresponding edit? Well, today we are here to fulfill your wishes.

Keep reading to learn how to easily track changes made on an Excel worksheet, view them on separate worksheets or the same worksheet itself, and finally accept or reject the changes after reviewing them. Also, it’s easy to disable tracking, oh yes, we’ll cover that topic too. Hope you like it!

Part 1: How to Enable Track Changes

Step 1: Open the Excel worksheet where you want to track changes.

Click the REVIEW tab at the top of the window.

Under the REVIEW tab, click the Track Changes drop-down menu and click the Highlight Changes option.

Step 2: In the Highlight Changes window, check Track changes while editing " option corresponding to the checkbox. This also shares your workbook. Now, under the

Highlight Changes

section, select the checkbox corresponding to the time, then select Alloptions.

Finally, select the checkbox corresponding to the on-screen highlight change

and click the OK button. That’s all. The Track Changes feature is now successfully enabled for your Excel worksheet.

Part 2: How to View Tracked Changes on the Same Excel Worksheet

Section 1 Enable the

Track Changes

feature. If you want to see changes tracked from the same worksheet itself, you can refer to the following steps.

Step 1

: Double-click any cell to edit its contents.

Step 2

: You can change the value in the selected cell. After editing is complete, the edited cell will be highlighted in blue, and a blue arrow will be added to the upper left corner of the cell to indicate the change.

Step 3

: If you hover over an edited cell, you can view the details of the edit, including Who edited the cell, when it was edited, and the values ​​before and after the cell.

Part 3: How to View Tracked Changes on a Separate Worksheet

If you want to view on a separate worksheet instead of the original worksheet All track changes, you can choose to do that as well.

Step 1

: Click the REVIEW tab at the top, click the Track Changes drop-down menu, and then click Highlight Changes Options.

Step 2

: Now under the Highlight Changes window, check the list with On the new worksheet Change the checkbox corresponding to the option, and then click the OK button.

Step 3

: Now a new worksheet named History will open in front of you containing all the users All details of all edits made.

Part 4: How to Accept/Reject Tracked Changes

You can also choose to view all tracked changes individually and accept them all individually or at once or Reject them.

Step 1

: Just like the previous section, first click on the REVIEW tab at the top, then click on the Track Changes drop-down menu, Then click on the Accept/Reject Changes option.

Step 2

: If your workbook was not saved, you will receive a warning message stating that your workbook will now be saved . Click the OK button to save your workbook and continue.

Step 3

: A new window will now open in front of you with the name Select Changes to Accept or Reject.

Select the checkbox corresponding to the option and select Not yet reviewed from the associated drop-down menu. You can also change these options to your liking.

Click the OK button after completion.

Step 4: You will now be shown each tracked change with all the details, which you can accept by clicking on " or "Reject" buttons to accept or reject each of them.

If you want to accept all tracked changes at once, please click the "

Accept All" button, if you want to reject all tracked changes at once, please click "Reject All" button.

Part 5: How to Disable Track Changes

If you want to completely disable Track Changes, it's very simple.

Step 1: Click the REVIEW tab at the top of the window again, click the Track Changes drop-down menu, and then click Highlight Changesoptions.

Step 2: In the Highlight Changes window, uncheck the box with "Track when editing Change the checkbox corresponding to the " option. This also shares your workbook.

Click the

OK button after completion. That’s all. This will disable the Track Changes functionality for you.

The above is the detailed content of How to track changes in Microsoft Excel. For more information, please follow other related articles on the PHP Chinese website!