Keep track of worksheet changes with Excel's shared worksheet feature

With Excel's shared worksheet feature, you can view other users' insertions and deletions and decide whether to keep or delete them. Mary Ann Richardson explains how to use this feature.

At the end of a quarter, you might distribute a summary sales worksheet to all department heads. To keep track of their changes, insertions, and deletions, you need to designate the workbook as a shared workbook before distribution. To do so, follow these steps:

  1. Go to Tools | Share Workbook.
  2. 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:

  1. Open the workbook and go to Tools | Track Changes.
  2. Click Accept Or Reject Changes.
  3. Click the When text box and select Not Yet Reviewed.
  4. Select Everyone from the Who text box.
  5. Click OK.

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.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox