Question

Select cell A1. Activate the Track Changes feature, highlight all changes on screen, click the When check box to deselect it, and then create a History worksheet. Select the data on the History worksheet, copy it to the Clipboard, add a new worksheet (in the third position), and paste to keep source column widths. Rename the sheet Changes.

Answer 1

The Track changes feature in Microsoft Excel is used to monitor changes made to a or all worksheets in a workbook. These changes can also be compiled in a new worksheet.

Step-by-step explanation:

To track changes made to a cell or group of cells and save it to a new worksheet, go to the review tab, click on the Track Changes option and select Highlight Changes in the changes group, then click on the highlight track changes dialog box, input "All" in the "When" text box option and click the "list track change in new sheet" option to save changes in a new worksheet, then click ok.