Excel Tips: Tracking Changes Made to Your Workbook

To track changes in a workbook in Excel, you can use the following steps:

1. Navigate to the Review Tab:

• Open your Excel workbook.

• Go to the "Review" tab in the Excel ribbon.

1. Click on "Track Changes":

• Within the "Review" tab, find and click on the "Track Changes" option.

1. Select "Highlight Changes":

• A dialog box will appear. Check the box for "Highlight changes on screen."

1. Choose Options (if needed):

• You can choose additional options such as tracking changes while editing, and whether to track changes on the current sheet or throughout the entire workbook.

1. Specify Who to Track:

• In the same dialog box, you can specify whose changes you want to track (Everyone, Everyone but Me, or a specific user).

1. Set a Password (optional):

• If desired, you can set a password to prevent others from turning off the change tracking.

1. Click OK:

• Once you've adjusted the settings, click "OK" to apply the changes.

1. Review Changes:

• Excel will now highlight changes made by the selected users, making it easy for you to review and accept or reject those changes.

This feature is particularly useful when multiple users collaborate on a workbook, allowing you to keep track of modifications made over time.