Now in this video we will see that how we can track changes in an shared Excel workbook.
So for that we will go to our REVIEW tab and see track changes option in changes column, when we open this we can see a highlight changes option, when we will open that particular option we can see a checkbox saying 'Track changes while editing. This also share your workbook'. We will then mark that checkbox.
Now suppose if we make changes in any part of our workbook we can see a different kind of highlight marked on that particular cell. Whenever we hover our mouse on that particular cell we can see when this change was made and by whom, and it also mentions about the change made from this to that.
Now we have another option in our track changes column which is 'Accept or Reject changes', which will show us 'Which changes' option showing when, who and where the changes have taken place.
Now suppose if we make any change then we will see an option of accept and reject changes in our workbook, this means that the change which we have done is accepted or rejected by another user or not.
Now to make all clear, we have another option of 'list changes made in another sheet', which will save the list of changes which we make in our main sheet into another sheet.
So this is how track changes in shared Excel workbook works.
MS Excel tracks changes by storing the original content and then recording the changes made to it. The original content is stored in a hidden copy of the workbook and is called the "original" version.
The following are some of the different types of changes that can be tracked in MS Excel:
Inserting new rows or columns in a spreadsheet
Changing cell formatting (e.g., font size, color)
Changing cell contents (e.g., text, numbers)
Deleting cells or rows
You can use Track Changes to:
Track changes made by more than one user
Review the history of edits and comments
Accept or reject edits and comments
Revert to an earlier version of the document
Track Changes lets you track any edits made to an Excel workbook by displaying all these changes in a separate window. You can review all these changes before saving them, and it will also help you find out who has made which change to your workbook.
To turn on Track Changes in MS Excel, first open the Review tab. You will see a menu for Track Changes. Click on this menu, then select either to turn them off or on.
Very good 👍👍
I learned a lot of formulas and functions through this lecture in free of cost. Thanks
Please give us an assignment or workbook to download and practice Excel after watching videos.
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR