Clear the Highlight changes on-screen check box. If you are prompted to save the workbook, click OK. In the Select Changes to Accept or Reject dialog box, do any of the following: To accept or reject Do this Changes that are made after a particular date Select the When check box, click Since date in the When list, and then type the earliest date after which you want to review the changes.
Changes that are made by another user Select the Who check box and then, in the Who list, click the user whose changes you want to review. Changes that are made by all users Clear the Who check box. Changes that are made to a specific area Select the Where check box, and then type the cell reference of the sheet range.
Changes to the entire workbook Clear the Where check box. For each change, click Accept or Reject. Notes: If you are prompted to select a value for a cell, click the value that you want, and then click Accept. You must accept or reject a change before you can advance to the next change. All changes must be saved before they can be listed on the history sheet. Tips: To print the history sheet, click Print on the File menu, select the print options you want, and then click Print. Select the Create a copy check box, and then click OK.
Save the workbook that contains the copied history sheet. When you use change tracking, consider the following: Change tracking differs from the undo operation and does not create a backup copy You might expect that change tracking creates a backup copy of the workbook before changes are made, or that you can undo any of those changes.
Some types of changes are not tracked Changes that you make to cell contents are tracked, but other changes, such as formatting changes, are not tracked.
The change history is kept only for a specific interval By default, when you turn on change tracking, the change history is kept for 30 days to keep the size of the workbook manageable.
The oldest part of the change history is periodically deleted Excel determines the change history that is kept by counting back from the current date. Excel provides the following ways to access and use the stored change history.
Onscreen highlighting Excel can outline changed areas in a different color for each user and display the basic details as a comment when you rest the pointer over each changed cell. History tracking Excel can display a separate history sheet that provides a printable list of change details on which you can filter to find the changes that you are interested in.
Change reviewing Excel can step you through the changes in sequence so that you can decide whether to accept or reject each change. Need more help? Expand your skills. Get new features first. A subscription to help make the most of your time. Smart assistance features. Ad-free email. Back up and access files across devices.
Try one month free. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon.
Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! To specify. Do this. You can also click and drag the New Group line or whatever its new name is to another position in the Review list. Click the Add button to move each command to the group. Check the box that says Track changes while editing … and the box that says Highlight changes on screen.
Now every change made to this spreadsheet is tracked and marked with a blue border and a tiny blue triangle upper left corner , which appears in the edited cells. However, you can also track changes in a local or personal copy, as seen throughout this lesson. You can also view changes on a new worksheet, sometimes called the Tracked Changes history. The history lists everything in your worksheet that has been changed, including the old value previous cell content and the new value current cell content.
To remove the History worksheet from your workbook, you can either save your workbook again or uncheck the box next to List changes on a new sheet in the Highlight Changes dialog box. Tracked changes are really just suggested changes. To become permanent, the changes must be accepted. On the other hand, the original author may disagree with some of the tracked changes and choose to reject them.
When tracking is enabled, Excel will keep track of the changes that you or others who have access to your workbook have made. This includes data insertions, deletions, and more. While this feature is available in a few Microsoft Office products, Microsoft Excel is somewhat unique in that change tracking is available only in shared workbooks. While typically a shared workbook would be stored in a location where others who need to can access it, you can also track changes using a copy you only have access to.
The Highlight Changes dialog will be shown. In order for you to be able to track your changes, you need to share your workbook. The remaining controls on this dialog will become enabled; using them you can choose exactly how changes will be tracked and highlighted.
For example, you can choose to only track changes made by specific users, or even changes that have been made to a specific cell range. Leave the default settings unchanged and click OK:. Delete the contents of cell A1. This action will delete the title text that was inside of this cell.
0コメント