How to track changes in Excel 2007如何跟踪变化，在Excel 2007中

Posted on September 5, 2008 at 5:29 am张贴于2008年9月5日在上午05时29分

Are you looking for a way to track changes made to an Excel spreadsheet.您是否正在寻找一种方法来跟踪所做的更改Excel试算表。 In an earlier post, I wrote how you can在早先的职位，我写的如何，您可以 protect an Excel workbook using a password保护Excel工作簿中使用密码 , but there are many cases where you have to distribute a file and allow others to edit it also. ，但是也有很多的情况下，你必须分发一份文件，并允许其他人编辑，也。

In these types of cases, it’s handy to be able to track any changes made to the original Excel spreadsheet.在这些类型的案件，它的方便，以便能够追踪所作的任何更改，原来的Excel试算表。 Tracking changes in Excel is fairly straight-forward and here’s how you do it.跟踪更改在Excel中是相当直接的弘扬和在这里的你如何去做。

First, open Excel and click on the Review ribbon.首先，打开Excel ，然后按一下就检讨丝带。 At the far right, you should see an option called “ Track Changes ”.在极右派，您应该可以看到一个选项，称为“ 轨道的变化 ” 。

Click the button and choose Hightlight Changes .按一下按钮，并选择hightlight的变化 。 You’ll get a dialog box where you now need to check off the option “Track change while editing.您将获得一个对话方块，让您现在需要检查小康的选项“的轨道变化，而编辑。 This also shares your workbook” . 这也是您的工作簿中的股份“ 。

You have several options here for When , Who, and Where.您有几个选项这里时，谁，和地点。 For When , All means every change will be highlighted. 时，一切手段，每一个变化将突出。 You also have the option of highlighting changes from the last time you saved the document, since a specific date, or changes that have not yet been reviewed.您也可以选择突出的变化，从您最后一次保存的文件，因为某一个具体日期，或变更尚未审查。

If you select Who, you can choose to track changes made by anyone or changes made by everyone except you.如果您选择谁，您可以选择轨道的变化所作出的任何人或所作的改动，大家除了你。 The Where filter 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.只要按一下按钮，在权利和选择的单元格区域您想要保留的轨道上来。

Finally, you can un-check the Highlight changes on screen option if you do not want others to know you are tracking changes.最后，您可以取消勾选突出的变化，在屏幕上选择，如果您不想让其他人知道你正在跟踪的变化。 By default, once you start tracking and this option is selected, any changed cell will show a small arrow at the top left to indicate it was changed.默认情况下，一旦你开始跟踪和选择此选项，任何改变，细胞会显示一个小箭头，在左上角显示，这是改变。

If you deselect the Highlight changes on screen option, that little blue arrow won’t show up.如果您取消突出的变化，在屏幕上的选项，即小蓝箭头，将不会显示出来。 Also, if you click on a changed cell (with Highlight changes on screen turned on), you’ll get a little popup window showing what the value was changed from and to and at what time.另外，如果您按一下改变的细胞（与突出的变化，在屏幕上打开），您将获得一个小弹出窗口，显示什么值改变，并从和在什么时候。

So what you can do, for example, is hide the changes on the screen by not checking the box, then send out your file to everyone who has to make changes to it, and when you get it back, just go to Track Changes and Highlight Changes and recheck the box!因此，您能做什么，举例来说，是隐藏的变化，在屏幕上，不勾选方块，然后传送出您的文件，大家谁也作出改变，并且当您取回，只要进入轨道的变化和突出的变化及复查的方块！

After this, you’ll need to either approve or reject the changes.在此之后，您需要批准或拒绝的变化。 So even though someone has made a change, it does not necessarily have to be permanent.因此，即使有人提出了改变，这并不一定要永久性的。 You can review all the changes and pick and choose which ones you want to keep or want to discard.您可以在审查所有的变化和挑选哪些您想要保留或要舍弃。

Simply click on Track Changes and choose Accept/Reject Changes .只要按一下上轨道的变化，并选择接受/拒绝的变化 。 Select the options to choose which changes you want to accept or reject.选择所需的选项，以选择哪些变化，您要接受或拒绝。 So whatever options you selected when turning on change tracking the first time, choose those again.所以，无论是选择时所选取的转折变化的跟踪第一时间，选择那些一次。

Click OK and Excel will begin to show you each change that was made and give you the option to Accept or Reject.单击确定和Excel就会开始向您显示每个改变了，并让您选择接受或拒绝。

After you have finished reviewing all of the changes you can click on Track Changes again and Highlight Changes, and you’ll notice that the box for “ List changes on a new sheet ” is now enabled.之后，您已完成检讨所有的变化，您可以点击上轨道的变化，再次和突出的变化，您会发现，方块“ 名单的变化，一个新的资产负债表 ”现在已经启用。 For some reason this option is not enabled the first time you turn on change tracking in Excel.出于某种原因这个选项是不启用的第一时间，您打开变更跟踪在Excel 。

Check the box and click OK and now all of the changes that were performed will be shown in a new Excel sheet:选中该框并单击确定，现在所有的变化均将显示在一个新的Excel工作表：

That’s it!这样就大功告成了！ Now you can track any changes made to your Excel spreadsheet easily by using this built in feature.现在，您可以跟踪所作的任何更改，您的Excel试算表，很容易使用这个内置的功能。 By the way, if you read the post mentioned above on how to password protect an Excel file, you might be interested in the article on由的方式，如果您阅读后上述就如何密码保护Excel文件，您可能有兴趣在文章中就 how to crack an Excel password如何打击一个Excel密码 ! ！ Enjoy!享受！

Enjoyed this post?享有这个职位呢？ Subscribe to Online Tech Tips via订阅在线科技提示通过 RSS Feed RSS馈送 or via或通过 Email电子邮件 and receive free daily productivity tips.并获得免费的每日生产力的秘诀。

» Filed Under »提交下 MS Office Tips的MS Office的秘诀