1、就像前面的部分一样，首先点击顶部的REVIEW选项卡，然后点击Track Changes下拉菜单，然后点击Accept/Reject Changes选项。2、如果您的工作簿未保存，您将收到一条警告消息，说明您的工作簿现在将被保存。点击确定按钮保存您的工作簿并继续。3、现在将在您面前打开一个新窗口，名称为Select Changes to Accept or Rej...
Allows you to choose a particular range of cells you want to track the changes for as opposed to tracking the whole workbook. You can drag to select the cells directly while the dialog box is still open. If a range of cells is specified then Excel will only track the changes within that...
1、打开要跟踪更改的Excel工作表。 点击窗口顶部的REVIEW选项卡。 在REVIEW选项卡下,单击Track Changes下拉菜单,然后单击Highlight Changes选项。 2、在“突出显示更改”窗口中,选中与“编辑时跟踪更改”选项对应的复选框。这也共享您的工作簿。 现在,在突出显示更改部分下,选中与时间对应的复选框,然后选择全部选项。
第1 步:打开要跟踪更改的 Excel 工作表。 点击窗口顶部的REVIEW选项卡。 在REVIEW选项卡下,单击Track Changes下拉菜单,然后单击Highlight Changes选项。 第2 步:在“突出显示更改”窗口中,选中与“编辑时跟踪更改”选项对应的复选框。这也共享您的工作簿。 现在,在突出显示更改部分下,选中与时间对应的复选框,然后...
In Excel 365, there isn't a built-in feature that allows you to completely block users from deactivating the "Track Changes" option once it has been activated. However, you can take some measures to make it more difficult for users to disable this feature: ...
Section 1: How to Enable Track Changes Functionality Step 1: Open the Excel sheet that you want to track changes. Hit theREVIEWtab at the top of the window. Under theREVIEWtab, click on theTrack Changesdropdown and then click on theHighlight Changesoption. ...
Excel 2016 Important: This article explains an older method of tracking changes using a "Shared Workbook." The Shared Workbook feature has many limitations and has been replaced by co-authoring. Co-authoring doesn't provide the ability to track changes. However, if you and others ...
{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:3602444"},"conversation":{"__ref":"Conversation:conversation:2249190"},"subject":"Re: Track Changes in Excel disappearing and/or not showing after saving","moderationData":{"__ref":"Moderation...
If you have ever used the "Track Changes" feature in Microsoft Word, then you know that the changes you make aren't deleted, but they are shown with a strikethrough and typically highlighted in red. If you have used the ...
Related:How to Lock Cells in Excel Making Track Changes in Microsoft Excel Now that we have enabled tracking changes, you can begin making your changes on any Microsoft Excel cell or group of cells. For instance, in the mock project below, we have made changes in cell C4 from “Software ...