Page 495 - Excel 2013 All-in-One For Dummies

5. (Optional) If you don’t want to track all changes in the workbook, click the When drop-down button and then choose the menu item from its drop-down menu (Since I Last Saved, Not Yet Reviewed, or Since Date).
By default, Excel tracks the changes made by anybody who opens and edits the workbook (including you). If you want to exempt yourself from change tracking or restrict it to a particular user, select the Who check box and then choose Everyone But Me or the user’s name from the Who drop-down menu.
6. (Optional) If you want to restrict change tracking, click the name of the person to whom you want to restrict change tracking in the Who drop-down menu.
Note that selecting any option from the Who drop-down menu automati- cally selects the Who check box by putting a check mark in it.
By default, changes made to any and all cells in every sheet in the work- book are tracked. To restrict the change tracking to a particular range or nonadjacent cell selection, select the Where check box and then select the cells.
7. (Optional) If you want to restrict change tracking to a particular cell range or cell selection in the workbook, click the Where combo box and then select the cell range or nonadjacent cell selection in the workbook.
Clicking the Where text box and selecting a cell range in the workbook automatically selects the Where check box by putting a check mark in it.
By default, Excel highlights all editing changes in the cells of the work- sheet on the screen by selecting the Highlight Changes on Screen check box. If you don’t want the changes marked in the cells, you need to deselect this check box.
8. (Optional) If you don’t want changes displayed in the cells onscreen, click the Highlight Changes on Screen check box to clear its check mark.
Note that after you finish saving the workbook as a shared file, you
can return to the Highlight Changes dialog box and then select its List Changes on a New Sheet check box to have all your changes listed on a new worksheet added to the workbook. Note too, that if you select this check box when the Highlight Changes on Screen check box is selected, Excel both marks the changes in their cells and lists them on a new sheet. If you deselect the Highlight Changes on Screen check box while the List Changes on a New Sheet check box is selected, Excel just lists the changes on a new worksheet without marking them in the cells of the worksheet.
Workbook Sharing 101 477
Book IV Chapter 3
Sending Workbooks Out for Review