How to Keep Track of Changes in an Excel Document
Tracking Changes
- 1). Start Microsoft Excel and open the file you want to change.
- 2). Open the Tools menu and select Track Changes, then Highlight Changes.
- 3). In the Highlight Changes dialog box, select "Track changes while editing."
- 4). Select "Highlight changes on screen."
- 5). Open the When menu and select All.
- 6). Open the Who menu and select Everyone.
- 7). Click OK.
- 8). Click OK. This will save your changes and your file/workbook.
- 9). Enter your new changes.
Source...