Keep track of worksheet changes with | Excel |

Takeaway:

With Excel's shared worksheet feature, you can view other users' insertions and

deletions and decide whether to keep or delete them.

To do so, follow these steps:

Go to Tools Share Workbook. Under the Editing tab, select the check box, and

then click OK.

In order to view changes as other users make them to the worksheet, follow these steps:

Open the workbook and go to Tools Track Changes. Open the Highlight

Changes.

In the Highlight Changes dialog box, select "Track changes while editing."

Select "Highlight changes on screen."Open the When menu and select All.

Open the Who menu and select Everyone.Click OK.Click OK.

This will save your changes and your file/workbook.Open the Tools menu and

Track Changes menu and select Accept and Reject Changes option.

In the Select Changes to Accept or Reject dialog box,

select "Not yet reviewed" to see all changes or "Since date" to see changes after
a certain day.

Click OK.

In the Accept or Reject Changes dialog box, review the edits to the spreadsheet.

Select the Reject or Accept button for each edit.

Excel will walk you through all the changes since the last review.

At each change, you can decide whether to keep (accept) or delete (reject) the

change.