Track Changes

If you are working with a project team to develop a Spreadsheet-based DSS, you should use the track changes feature in Excel. When others are checking the application, editing formulas or formats, or adding data, it is helpful to see what changes were made.

In Excel, Choose Tools/Track Changes/Highlight Changes. If you then change data in a cell, that cell will be outlined and it will contain a small triangle in the upper left corner of the cell. If you move the mouse pointer over the cell, a comment will appear informing you of the change. Try it!

appeared in DSS News 03/17/02