How to Keep Track of Changes in an Excel Document

Video Transcript

"Hi my name is Dave Andrews and today I am going to show you how to keep track of changes in an Excel document. Let's open up Excel and I am clicking on the start button and go to all programs. Let's find Microsoft Office and let's just open up Excel. Now we are going to enable the feature in Excel that tracks changes. To do that let's go to review which is a tab on the top here and under the changes area let's pull the little drop down here next to track changes. Select highlight changes. This brings up the dialog that is going to enable to change tracking for us so just click this box and for when we want to leave that on all because that is the type of change that we want to track. We want to track every change ever made to this document. You can also track the changes since the document was last saved. For who I am going to leave that on everyone and say o'kay. Now it is going to prompt you to save this because in order to track the changes the file must be saved. I am just going to keep the default name of book one and we are going to save them. Now let's make some changes to my document. As you can see the cells that I have changed have a little arrow up here in the top let hand corner. If I move my mouse over them it pops up a little box that tells me exactly what was changed in the document. It will do this for all cells that are changed all the time because those are the options that will be selected. My name is Dave Andrews and I have just told you how to track changes in an Excel document."