Friday, June 17, 2011

How to Track History on Microsoft Excel


1. Click on the 'Review' tab in Excel 2007 or the 'Tools' tab in Excel 2003.
2. Click on 'Track Changes.'
3. Click on the 'Track changes while editing. This also shares your workbook' check box.
4. Click on any feature's check box that you want to track. For example, if you want to track who made changes, click on the 'Who' check box.
5. Click on the drop-down box to the right of the feature you checked in Step 4 to select what kind of changes you want to track. For example, click on 'All' changes.
6. Make sure the default option 'Highlight changes on screen' box is checked, then click on 'OK.' Any changes made to the document will be highlighted on your Excel spreadsheet.

Blogger news