{"id":18777,"date":"2013-05-08T15:52:36","date_gmt":"2013-05-08T10:22:36","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18777"},"modified":"2024-04-12T14:24:23","modified_gmt":"2024-04-12T08:54:23","slug":"track-accept-and-reject-changes-to-workbooks","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/","title":{"rendered":"Track, Accept, and Reject changes to Workbooks"},"content":{"rendered":"<h4><strong>Track, Accept, and Reject changes to Workbooks<\/strong><\/h4>\n<p>Excel 2013\u00a0workbook, you can decide which changes to accept or reject by choosing the Accept\/Reject Changes option from the Track Changes\u00a0commandbutton\u2019s drop-down menu on the\u00a0Ribbon\u2019s Review\u00a0tab\u00a0(or pressing Alt+RGC).<\/p>\n<p>When you do this, Excel reviews all the highlighted changes made by you and others who\u2019ve worked on the shared file, enabling you to accept or reject individual changes.<\/p>\n<p>When you first choose the Accept\/Reject Changes option, Excel displays the alert\u00a0dialog\u00a0box, informing you that Excel will save the workbook. When you click OK to close this alert dialog box, the program opens the Select Changes to Accept or Reject dialog box, which contains the same three check boxes and associated drop-down items (When, Who, and Where) as the Highlight Changes dialog box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30837\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg\" alt=\"03\" width=\"300\" height=\"193\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03.jpg 394w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>By default, the When check box is selected along with the Not Yet Reviewed setting in the Select Changes to Accept or Reject dialog box. When this setting is selected, Excel displays all the changes in the workbook that you haven\u2019t yet reviewed for everyone who has modified the shared file.<\/p>\n<p>To review only those changes you made on the current date, choose the Since Date item from the When drop-down menu. To review changes made since a particular date, edit the current date in the Since Date drop-down list.<\/p>\n<p>To review only changes that other people have made, only those changes you\u2019ve made, or only those changes a particular co-worker has made, choose the appropriate item (Everyone But Me, your name, or another user\u2019s name) from the Who drop-down menu.<\/p>\n<p>If you want to restrict the review to a particular range or region of a\u00a0worksheet, click the Where combo box and then select the range or nonadjacent\u00a0cell\u00a0ranges with the cells to review.<\/p>\n<p>After you select which changes to review in the Select Changes to Accept or Reject dialog box, click the OK button. Excel then closes this dialog box, highlights the cell in the worksheet that contains the first change to review, and opens the Accept or Reject Changes dialog box, where you indicate whether to accept or reject the change.<\/p>\n<p>To accept the change, you click the Accept button. To reject the change and keep the original value, you click the Reject button instead. Excel then highlights the next cell in the worksheet that needs reviewing, while at the same time displaying a description of the change in the Accept or Reject Changes dialog box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30840\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/042-300x141.jpg\" alt=\"04\" width=\"300\" height=\"141\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/042-300x141.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/042.jpg 439w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>If you know ahead of time that you want to accept or reject all the changes that have been made since you last reviewed the workbook or the date you specified, click the Accept All button or the Reject All button, respectively.<\/p>\n<p>When you accept or reject the last change identified in the workbook, the Accept or Reject Changes dialog box automatically closes, and you can then save the workbook (Ctrl+S) with the editing changes made as a result of this review.<\/p>\n<h3>Apply for MS Excel Certification Now!!<\/h3>\n<p><a href=\"https:\/\/www.vskills.in\/certification\/excel-online-certification-course\" target=\"_blank\" rel=\"noopener\">https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n<h4><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-excel-2003-professional\/\" target=\"_blank\" rel=\"noopener\"><strong>Back to Tutorial<\/strong><\/a><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>Track, Accept, and Reject changes to Workbooks Excel 2013\u00a0workbook, you can decide which changes to accept or reject by choosing the Accept\/Reject Changes option from the Track Changes\u00a0commandbutton\u2019s drop-down menu on the\u00a0Ribbon\u2019s Review\u00a0tab\u00a0(or pressing Alt+RGC). When you do this, Excel reviews all the highlighted changes made by you and others who\u2019ve worked on the shared&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[47],"tags":[5187,5188,5189,5186],"class_list":["post-18777","page","type-page","status-publish","hentry","category-ms-excel","tag-accept","tag-and-reject-changes-to-workbooks","tag-reject-changes-to-workbooks","tag-track"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Track, Accept, and Reject changes to Workbooks - Tutorial<\/title>\n<meta name=\"description\" content=\"Track, accept, and reject changes to workbooks. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Track, Accept, and Reject changes to Workbooks - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Track, accept, and reject changes to workbooks. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/\",\"name\":\"Track, Accept, and Reject changes to Workbooks - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg\",\"datePublished\":\"2013-05-08T10:22:36+00:00\",\"dateModified\":\"2024-04-12T08:54:23+00:00\",\"description\":\"Track, accept, and reject changes to workbooks. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Track, Accept, and Reject changes to Workbooks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Track, Accept, and Reject changes to Workbooks - Tutorial","description":"Track, accept, and reject changes to workbooks. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/","og_locale":"en_US","og_type":"article","og_title":"Track, Accept, and Reject changes to Workbooks - Tutorial","og_description":"Track, accept, and reject changes to workbooks. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:23+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/","name":"Track, Accept, and Reject changes to Workbooks - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg","datePublished":"2013-05-08T10:22:36+00:00","dateModified":"2024-04-12T08:54:23+00:00","description":"Track, accept, and reject changes to workbooks. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/03-300x193.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/track-accept-and-reject-changes-to-workbooks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Track, Accept, and Reject changes to Workbooks"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=18777"}],"version-history":[{"count":5,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18777\/revisions"}],"predecessor-version":[{"id":130099,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18777\/revisions\/130099"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}