Excel worksheets are frequently used for teamwork. We want to record and track the modifications made by each member. Today, we will learn how to use the Track Changes function.

Take this table as an example, we want to get the revision history of the data.

First, go to the Review tab, and click Highlight changes at  Track Changes.

Then, check Track Changes While Editing to track the changes in your sheet. By doing so, you can highlight the changes including time, reviser, and revisions.

Excel does not highlight the changes by default. It may be changed by checking Show track changes description. Changes you make afterward will display on the screen. After setting, click OK to save the file. Then it can be shared and revised.

Any changes to this document will trigger a mark in the upper right corner, where you can check the reviser, revision, and revision time.

How can we check the revisions as the number of changed records grows?

Quite simply, press Ctrl+S to save the document and click Track Changes. Then, check List changes on a new sheet before clicking OK. All modifications will be listed on a new sheet called History.

This is all about Track Changes. Did you get it?

WPS Spreadsheet could be an alternative to Microsoft Office Excel. WPS includes 100's of built-in formulas, pivot tables and more. WPS includes advanced animation, slide transitions, and support for video, images, audio and even Flash.