Home->Editing->Find and Select-> Replace

Review the Tracked Changes

So, what does Tracking look like? In this sample spreadsheet there are 7 records for "Cold Platter." Let's Find and Replace "Cold Platter" with "Pita Platter."

 

8. Try it: Make Some Changes

Select Column E: Products.

Go to Home->Editing->Find and Select.

Click on Replace.

 

You will be prompted to enter the following:

Find What: Cold Platter

Replace With: Pita Platter

Click Replace All to make 7 replacements.


What Do You See? There should be a border around the cells that were changed.

 

When you run your cursor over the highlighted cell you should see the name of the person who changed the data, when it was changed and what was changed.


One more time, keep going...!

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.3. Maintain shared workbooks: Highlight Tracked Changes