Try the Excel Course for Free!

Accept or Reject Changes to a Shared Workbook in Excel – Tutorial

/ / Excel 2016, Latest, Microsoft, Office 2016
Accept or Reject Changes to a Shared Workbook in Excel - Tutorial: A picture of the

Accept or Reject Changes to a Shared Workbook in Excel: Overview

            You can accept or reject changes to a shared workbook in Excel after you view the changes that have been made. To accept or reject changes to a shared workbook in Excel, click the “Track Changes” button in the “Changes” group on the “Review” tab. 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. In this dialog box, use the “When,” “Who,” and “Where” checkboxes and drop-down menus to filter for the changes you want to review. After making your selections, click “OK” to begin reviewing the selected changes.

            Next, each selected change will appear. It will show who made the change, when they made the change, and what they changed in the “Accept or Reject Changes” dialog box. 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. If there were multiple changes made to a cell, you may have to select which change to keep in the dialog box before pressing one of the buttons. When you are finished, the dialog box will close automatically. You can leave any time before then, if needed, by clicking the “Close” button to exit.

Accept or Reject Changes to a Shared Workbook in Excel - Tutorial: A picture of the "Accept or Reject Changes" dialog box in Excel 2016.

Accept or Reject Changes to a Shared Workbook in Excel – Tutorial: A picture of the “Accept or Reject Changes” dialog box in Excel 2016.

Accept or Reject Changes to a Shared Workbook in Excel: Instructions

  1. To accept or reject changes to a shared workbook in Excel, click the “Track Changes” button in the “Changes” group on the “Review” tab.
  2. Click the “Accept/Reject Changes” command in the button’s drop-down menu to open the “Select Changes to Accept or Reject” dialog box.
  3. To filter for the changes that you want to review in this dialog box, use the “When,” “Who,” and “Where” checkboxes and drop-down menus.
  4. After your desired selections, click “OK” to begin reviewing the selected changes.
  5. Each selected change will appear. It will show who made the change, when they made the change, and what they changed in the “Accept or Reject Changes” dialog box.
  6. To accept the change shown, click “Accept” at the bottom of the dialog box.
  7. To reject the change shown, click “Reject” at the bottom of the dialog box.
  8. To accept all changes made, click the “Accept All” button.
  9. To reject all changes made, click the “Reject All” button.
  10. If there were multiple changes made to a cell, you may have to select which change to keep in the dialog box before pressing one of the buttons available.
  11. The dialog box will close automatically when you are finished.
  12. To leave any time before finishing, if needed, simply click the “Close” button to exit.

Accept or Reject Changes to a Shared Workbook in Excel: Video Lesson

            The following video lesson, titled “Reviewing Changes,” shows you how to accept or reject changes to a shared workbook in Excel. This video lesson is from our complete Excel 2016 through 2013 training, titled “Mastering Excel Made Easy v.2016-2013.”

TOP