Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Turn on Change Tracking in Excel 2013 Workbooks

(Optional) If you don’t want changes displayed in the cells onscreen, click the Highlight Changes on Screen check box to clear its check mark.

Note that after you finish saving the workbook as a shared file, you can return to the Highlight Changes dialog box and then select its List Changes on a New Sheet check box to have all your changes listed on a new worksheet added to the workbook.

Note too, that if you select this check box when the Highlight Changes on Screen check box is selected, Excel both marks the changes in their cells and lists them on a new sheet.

If you deselect the Highlight Changes on Screen check box while the List Changes on a New Sheet check box is selected, Excel just lists the changes on a new worksheet without marking them in the cells of the worksheet.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.