From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Tracking changes

Tracking changes

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Tracking changes

- We're looking at a worksheet called RecordedChanges. It's in the workbook called 11 - TrackingChanges. If you want to allow different people to make changes to this worksheet at the same time, you probably have already set this up as a shared workbook. Now this workbook is not shared. We don't see that in the title bar up top so we could start the process by going to Share Workbook. However, maybe you have never heard about shared workbooks yet, but you do see an option here on the Review tab called Track Changes, keep track of changes made to this document. This is especially useful if the document is almost done and you're working with others to make revisions or give feedback. Now, this feature is ideal when you've got multiple users, but let's not also forget you could be using it for yourself only, maybe you want to track the changes that you make to this file and nobody else has access to it at all. When you activate Track Changes and choose Highlight Changes, this dialog box…

Contents