Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Tracking changes in excel is a technique which is used to highlight a changes done by any user in a shared workbook, it highlights the cell which has been changed in to a different color, this option can be enabled when we share a workbook and is available in the changes section of the review tab, it gives us certain options such as when to highlight changes and whether to reflect the changes on the screen.
Track Changes Excel (Table of Contents)
Track Changes in Excel
When you are working with a large volume of data, what if your subordinates change something and you do not know what was the change he made. Isn’t it a time-consuming job to do it all over again (I hate redoing reports and calculations).
If the file you are working on is an expenses updater or deals updater, you need to be very careful about the unintentional changes by mistake. Excel track changes will watch the changes for you and save in critical moments.
How to Track Changes in Excel?
Before we head into the topic of track changes in excel, firstly we need to know where exactly the option to use it. Follow the below steps to find that option.
Step 1: Go to the Review tab.
Step 2: Now in this tab go to the Excel Track Changes option, which is there under Changes Section.
Work With Track Changes Option in Excel
Now we will see how exactly excel track the changes we made in excel. Consider the below data for this example.
Now before making any changes enable the option of track changes option. Follow Where to find the excel track changes option step.
From the above image, select Highlight Changes option. Once this option is selected below the dialogue box will open.
Now check the box excel Track Changes while editing. This also shares your workbook. Once this button is checked all the below option will be enabled.
Now we have multiple options When, Who, and Where. Before we go to the next step let us understand these options.
When: This option includes multiple other options as well. Whether you want to track since you last saved, All, Not yet reviewed, and since date option.
Who: This option has a couple of options. One is everyone and everyone but me.
Where: This is where you need to track changes in excel. If you want to track the whole sheet then do not check the Where box or else you can specify the range.
Now click on Ok button. Excel will ask your permission to save the workbook. Click on Ok to save it.
Now make anyone change to any one of the cells within this range. I have to change the cell C6 value from 2208 to 1800. Track changes automatically inserted the comment for me.
Look how track changes option has done the trick for me. It included my name, the date when I made the changes, the time, and the cell that I have changed. It also mentions the previous value along with the new values.
How to make the List of Track Changes in a separate sheet
We have learned how we can track our changes. I can record all those changes in the separate sheet itself. I think that is the coolest option you will ever get. Follow the below steps to explore this option.
Step 1: Again, click on Highlight Changes option and select the option of List changes on a new sheet.
Step 2: Click on the OK button. This would instantly create a new sheet named History.
Step 3: You can just see this sheet. This sheet is read-only. If you save the workbook then this sheet will disappear.
Validate Changes and Accept or Reject
At any given point of time, admin can accept or reject changes. When the users make changes you, review those changes. You can either accept or reject the changes.
Follow the below steps to explore this option.
Step 1: Click on Track Changes drop down and select the Accept / Reject Changes option.
Step 2: Click on the Accept / Reject Changes option. This will open up the below dialogue box.
Step 3: You can explore all the options under each section to accept or reject the changes. Click on OK button and it will open up the below box. This will show the changes one by one.
Step 4: If the changes are ok to go ahead click on Accept or else click on the Reject option. If you want to accept once for all click Accept All. If you want to reject once for all click on Reject All.
How to Disable this?
At any given point of time, we can disable this option by just unchecking Track Changes while editing. This also shares your workbook. Once this box is unchecked track changes option stops tracking the changes.
Track Changes vs Normal Comments
Now we will see the major differences between Track Changes and Normal Comments.
|Track Changes||Normal Comments|
|Track changes comments are auto inserted by the excel itself. No need of manually typing.||Unlike track change comments, these types of comments are not auto inserted.|
|We can extract all the comments in a separate sheet.||We cannot extract comments unless we use VBA coding.|
|Easy and super-fast.||Tedious and time consuming|
This has been a guide to Track Changes in Excel. Here we discuss how to track changes in excel, list them and validate changes along with practical examples. You may learn more about excel from the following articles –
- Explanation of Tracking Error Formula
- How to Create Drop Down List in Excel?
- Auto Option Format in Excel
- Find the Remove (Delete) Blank Rows in Excel
- Highlight Other Row in Excel
- Top 5 Useful Methods to Insert Multiple Rows in Excel
- How to Insert Hyperlinks?
- How to Format in Excel?
- How to make Excel Tables
- Watch Window Excel
- Convert Numbers to Text using Excel