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!享受！
» Filed Under »提交下 MS Office Tips的MS Office的秘訣
 Save this page 保存此頁 |  Stir it up on Mixx 轟動起來就mixx | |
 Add to Reddit 添加到reddit |  Stumble this page 蹣跚此頁 |
Related Posts 相關文章
- How to securely password protect an Excel file如何安全密碼保護Excel文件
- How to remove, crack, or break a forgotten Excel xls password如何刪除，裂紋，或打破一個被遺忘的Excel的xls密碼
- How to add comments to an Excel Worksheet cell如何添加評論到Excel工作細胞
- How to use Data Validation in Microsoft Excel to create dropdown lists如何使用數據驗證在Microsoft Excel中創建下拉名單
- How to hide text in MS Word 2007如何隱藏文本在MS Word 2007中
