Excel allows you to track changes to a spreadsheet. This really helps especially when several people update the same spreadsheet or you are working with a very large or an important spreadsheet. For example to track changes, follow these steps:
- Open up a new spreadsheet in Excel.
- Enter the following data:
Enter 5 in A1
Enter 15 in A2
Enter 5 in A3
Enter 10in A4
Enter 20in A5
- Now, choose File/Save As. Give your workbook a name and click Save.
- Choose Tools/Track Changes/Highlight Changes.
- Next, click in cell A2 and change the data to 10, then click somewhere away from cell A2.
- You will see that cell A2 is now outlined and contains a small triangle in the upper left corner of the cell. Move the mouse pointer over cell A2, and a comment will appear informing you that cell A2 was changed from 15 to 10.
This will track the change on any cell always indicated by a triangle, however it only tracks the most recent change only. There is no history contained in the tracks, so it may beneficial in some applications.
Tip comes from Sue Whitehouse with added information form myself and is extracted from Tipworld.
Just click on the button for the Tiproom's Home Page.