Tracking Changes

graphics/microsoft54.gif

As you build and fine-tune a workbook ”particularly if you are sharing workbooks with co-workers ”you can keep track of all the changes that are made at each stage in the process. The Track Changes feature makes it easy to see who made what changes and when, and to accept or reject each change. To take full advantage of this feature, turn it on the first time you or a co-worker edits a workbook. Then, when it's time to review the workbook, all the changes will be recorded. You can review tracked changes in a workbook at any point. Cells containing changes are surrounded by a blue border, and the changes made can be viewed instantly by moving your mouse pointer over any outlined cell . When you're ready to finalize the workbook, you can review each change and either accept or reject it.

Turn On the Track Changes Feature

graphics/one_icon.jpg

Click the Tools menu, point to Track Changes, and then click Highlight Changes.

graphics/tow_icon.jpg

Select the Track Changes While Editing check box.

graphics/three_icon.jpg

Select the When, Who, or Where check box. Click an associated list arrow, and then select the option you want.

graphics/foure_icon.jpg

Click OK.

graphics/five_icon.jpg Make changes in worksheet cells.

Column and row indicators for changed cells appear in red. The cell containing the changes has a blue outline.

graphics/six_icon.jpg

To view tracked changes, position the mouse pointer over an edited cell.

graphics/12inf08.jpg

graphics/12inf09.jpg

Accept or Reject Tracked Changes

graphics/one_icon.jpg

Click the Tools menu, point to Track Changes, and then click Accept Or Reject Changes. If necessary, click OK in the message box.

graphics/tow_icon.jpg

Click OK to begin reviewing changes.

graphics/three_icon.jpg

If necessary, scroll to review all the changes, and then click one of the following buttons :

  • Click Accept to make the selected change to the worksheet.

  • Click Reject to remove the selected change from the worksheet.

  • Click Accept All to make all of the changes to the worksheet after you have reviewed them.

  • Click Reject All to remove all of the changes to the worksheet after you have reviewed them.

graphics/foure_icon.jpg

Click Close.

graphics/12inf10.jpg

graphics/12inf11.jpg

Did You Know?

You can keep track of revisions by tracking changes . Use the Track Changes feature to follow important changes in data, even if you are the only user of a worksheet.

The title bar changes to alert you of shared status . When you or another user applies the Track Changes command to a workbook, the message "[Shared]" appears in the title bar of the workbook to alert you that this feature is active.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net