-The tracking features of Excel are very helpful in keeping track of changes to your work. -You can easily review all of the changes that have been made to your work sheet, and you can also accept or reject them. -There are a few things to keep in mind about the tracking features of Excel: first, they are very helpful in keeping track of changes to your work; second, you can easily review all the changes that have been made; and third, you can either accept or reject them. ..
- If you want to revert the spreadsheet back in time, you need to undo the changes and create a new spreadsheet.
If you want to keep track of your changes, you need to turn on tracking. This means that any data stored in a cell will be tracked, but other changes like formatting are not. Other changes that are not tracked include hiding/unhiding rows and columns, comments, and cell values that change to due a formula recalculation.
If you make changes to an Excel workbook and then open the workbook again 45 days later, then you’ll be able to see the change history for all 45 days until you close the workbook. When you close it, any change history older than 30 days will be gone. That means the next time you open it, you won’t be able to see that change you had made 45 days earlier.
When you turn tracking on in the workbook, it becomes a shared workbook. This means that multiple users will be making changes to the document. ..
How to Enable Tracking in Excel To enable tracking in Excel, open the Excel spreadsheet you want to track and click on the “Track Changes” button. Then, select the data you want to track and click on the “Track Changes” button again. You can also change some of the settings if you want, such as whether or not to include formulas in your tracking.
Enabling Tracking
When you turn on tracking, Excel will keep track of every change you make to the document, including deletions and additions. This way, you can always see what changes were made to your document, and why. ..
When you’re editing a document, you can track changes by checking the “Track changes while editing” box. This will share your workbook with other people who are editing the same document. ..
When you save a document, you have several options including highlighting changes from the last time you saved the document, or changes that have not yet been reviewed.
If you check Who, you can choose to track changes made by anyone or changes made by everyone except you. The Where option allows you to track changes only for a specific portion of the spreadsheet. Just click the button at the right and select the range of cells you want to keep track of.
If you do not want others to know you are tracking changes, you can uncheck the Highlight changes on screen option. ..
In a recent study, people who changed their cell phone’s settings to Highlight changes on screen turned on found that the triangles didn’t show up when they changed the settings back to normal.
If you want to make changes to a file that is being sent to everyone who has to make changes, you can hide the changes by not checking the box and send the file out to everyone who has to make changes. When you get it back, you can check the box and make sure that all the changes have been made.
Configure Tracking
On the Advanced tab, you will find a number of settings that will help you track your work. The first setting is the Tracking Type. This setting can be set to either daily or weekly. If you want to track your work every day, then set the Tracking Type to daily. If you want to track your work every week, then set the Tracking Type to weekly. The next setting is the Frequency. This setting can be set to daily, weekly, or monthly. If you want to track your work every day, then set the Frequency to daily. If you want to track your work every week, then set the Frequency to monthly. The last setting is the Timestamps. This setting can be set to hourly or daily time stamps. If you want to track your work every hour, then set the Timestamps to hourly. If you want to track your work every day of the week, then set the Timestamps to daily. The last setting is called “Output Format.” This setting can be changed from “Text” (which is what most people use)to “PDF.” If you choose this option, then all of your tracking data will be saved in a PDF file that you can open and view later on any computer or device that has a PDF reader software program installed!
You can change the number of days for keeping change history to something other than 30 days. By default, changes are updated when the file is saved, but you can make it so that it is automatically done every few minutes. Lastly, you can choose how you want to deal with conflicts: either by being asked or simply letting the last change when saving the file win. ..
Viewing Changes
You can now click on the Track Changes button to see the changes made to the List on a new sheet box.
History has been added to the worksheet called History. You can view all the changes that have been made to that workbook.
After reviewing all the changes, you’ll need to either approve or reject them. You can review all the changes and then pick and choose which ones you want to keep or discard.
If you want to accept or reject changes, follow these steps:
- Simply click on Track Changes again and choose Accept/Reject Changes.
- Select the options to choose which changes you want to accept or reject.
- If you want to review all changes, just leave When checked and make sure it is set to Not Reviewed.
After clicking OK, Excel will show you each change that was made and give you the option to Accept or Reject. You can also Accept All or Reject All changes if you like.
If you reject a change, it will immediately revert back to the original value in that cell. This can cause formulas to break, etc. So be careful if you reject a change. ..
This built-in Excel spreadsheet feature lets you track any changes made to your spreadsheet easily. If you have any questions, post a comment. Enjoy!
