When multiple people are working on an Excel file, having a feature that allows you to identify changes and who is responsible becomes important. A common feature in Microsoft Office that allows individuals to monitor file changes is called Track Changes.
Unlike Microsoft Word, the “Track changes" on the ribbon in Excel. However, here's how to include it on the ribbon:
How to enable the path changes feature in Microsoft Excel
The Microsoft Excel ribbon is easily customizable. To include the Track Changes feature on your ribbon, follow these steps:
Step 1: turn on Microsoft Excel.
Step 2: Right click on the ribbon and from the options menu select Customize The tape.
Step 3: In the new menu, navigate to the drop-down menu below Customize Ribbon Header. You should have three options labeled All Tabs, Main Tabs, and Tools Tabs.
Step 4: From the drop-down menu, select an option. Customize Main tab bar.
Step 5: Below the drop-down menu, scroll through the main ribbon tabs until you select Review site.
Step 6: Click NewGroup located below the box, and a new field called New Group (Custom) should appear.
Step 7: Click an option Re label.
Step 8: Enter a new name For the group (for example, Track Changes) and choose an icon to represent it.
Step 9: Hover over the drop-down menu below the Choose commands from header. You should have nine options, ranging from common commands to custom tabs and groups.
Step 10: From the drop-down menu, select an option. Commands Not in Ribbon.
Step 11: Below the drop-down menu, scroll through the commands that aren't on your ribbon until you locate Track Changes (Legacy).
Step 12: Select Add >> الخيار.
Step 13: Go back to the box under Choose commands from, scroll through the list of commands and add commands. Accept/Reject Changes and tag changes to a change tracking group.
Step 14: To save the addition of new entries and group, click “OK".
Configure the Path Changes feature in Microsoft Excel
After you've customized the ribbon, the next step is to ensure the new Track Changes feature is present on your ribbon. You'll also need to configure how you want it to work.
Step 1: On your ribbon, select the tab audit.
Step 2: Verify that the new group Track changes Available on the review bar.
Step 3: Click “Mark Changes” and a new dialog box should launch.
Step 4: In the dialog box, check the box next to Track changes while editing.
Step 5: To configure when you want to track changes, you can choose any of these options:
- Since I last saved.
- Since the date (here, provide a specific date).
- Not yet reviewed.
- All of the above.
Step 6: To configure who has changes tracked, you can choose from Everyone but me or Everyone.
Step 7: Click the buttonOKTo save your preferences.
Note that the feature must be enabled. Highlight Changes In each file before you start editing as in Microsoft Word.
View and accept/reject changes
With the Track Changes feature now on your ribbon, you can easily identify new changes in a workbook or worksheet. New changes are often highlighted. Here's how it works:
Step 1: In a worksheet Excel Hover your mouse over a cell with a little shadow in the upper left corner.
Step 2: The action in step 1 reveals a comment box that displays the following information:
- Who made the change?
- When the change was made.
- What has changed in the cell.
Review the information to confirm if the changes are acceptable.
Step 3: Select the tabauditOn the tape.
Step 4: With the Change Tracking group selected, select the option Accept/Reject the changes.
Step 5: In the new dialog box, select the changes you want to accept or reject under the Who, Where, and When options.
- When: You can choose changes that have not yet been reviewed or specify a date.
- From: You can select which changes to review.
Step 6: After making your selections, click “OKTo start a new dialog box that displays all the changes made to Excel.
Step 7: In this dialog box, you can either accept all changes, reject them on the fly, or choose to do so individually.
Using the Comment Tool in Microsoft Excel
With the Track Changes feature, you can reduce version control issues in Excel by selecting changes to accept or reject. You can also use the commenting tool in Microsoft Excel to track changes or leave feedback for other collaborators.
