To close it before then, if needed, simply click the “Close” button to exit.Ī picture showing how to accept or reject changes to a shared workbook in Excel if using the traditional “Shared Workbooks” feature. When you are finished, the dialog box automatically closes. If multiple changes were made to a cell, you may have to select which change to keep in the dialog box before pressing one of the available buttons. At the bottom of the dialog box, click “Accept,” to accept the change shown “Reject,” to reject the change shown “Accept All,” to accept all changes made or “Reject All” to reject all changes made.
It shows who made the change, when they made the change, and what they changed.
Next, each selected change then appears, individually, in the “Accept or Reject Changes” dialog box. Then click the “OK” button to begin reviewing the selected changes. In this dialog box, use the “When,” “Who,” and “Where” checkboxes and drop-down menus to filter for the changes to review. Then click the “Accept/Reject Changes” command in the button’s drop-down menu to open the “Select Changes to Accept or Reject” dialog box. To accept or reject changes to a shared workbook in Excel, click the “Track Changes” button in the “Changes” button group on the “Review” tab of the Ribbon. If using the traditional “Shared Workbooks” feature in Excel, you can then either accept or reject changes to a shared workbook in Excel after highlighting the changes made. Overview of How to Accept or Reject Changes to a Shared Workbook in Excel
0 kommentar(er)
