| | Help by Product How-to Resources Support and Feedback Technical Resources Additional Resources Get Office 2007 | Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
- On the Tools menu, point to Track Changes, and then click Highlight Changes.
If the Track changes while editing check box is not selected, Microsoft Excel has not recorded any change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) for the workbook.
- Select the changes you want to see:
All changes that have been tracked Select the When check box and click All, and then clear the Who and Where check boxes.
Changes made after a particular date Select the When check box, click Since date, and then type the earliest date for which you want to view changes.
Changes made by a specific user Select the Who check box, and then click the user whose changes you want to view.
Changes to a specific range of cells Select the Where check box, and then enter a range reference, or select a range on the worksheet.
- Select how you want to view the changes:
Highlighted on the worksheet Select the Highlight changes on screen check box. To view the details about a change, rest the pointer over a highlighted cell.
Listed on a separate sheet Select the List changes on a new sheet check box to display the History worksheet (History worksheet: A separate worksheet that lists changes being tracked in a shared workbook, including the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved.). This check box is available only after you've turned on change tracking and saved some changes.
|