--- title: "Tip of the Week: Keeping Track of Changes Made in Excel - Blogs on IT Support and Cybersecurity for Small Business" description: "Let’s go over how to set up this capability. As a disclaimer, it will require you to edit some of your menu options, so reach out to your IT resource to confirm that it is okay to do so and to assist you if need be. You should also know that Track Ch" url: "https://colemantechnologies.com/blog/tip-of-the-week-keeping-track-of-changes-made-in-excel" date: "2026-06-07T04:09:44+00:00" language: "en-GB" --- ## Blogs on IT Support and Cybersecurity for Small Business Insights on cybersecurity, AI, and IT strategy to help business leaders reduce risk, improve performance, and make better technology decisions. [ Categories ](https://colemantechnologies.com/blog/categories "Categories") [ Tags ](https://colemantechnologies.com/blog/tags "Tags") [ Categories: All Categories ](https://colemantechnologies.com/javascript:void(0); "Categories") Search...Suggested keywords [ x ](https://colemantechnologies.com/javascript:void(0);) # Tip of the Week: Keeping Track of Changes Made in Excel [Coleman Technologies Blog](https://colemantechnologies.com/blog/categories/blog) [Tip of the Week](https://colemantechnologies.com/blog/categories/tip-of-the-week) [Coleman Technologies Admin](https://colemantechnologies.com/blog/blogger/darren-coleman) Wednesday, 14 October 2020 Let’s go over how to set up this capability. As a disclaimer, it will require you to edit some of your menu options, so reach out to your IT resource to confirm that it is okay to do so and to assist you if need be. You should also know that Track Changes won’t work if a spreadsheet contains a table that hasn’t been converted into a range. To make this conversion, **select the table**, navigate to the **Design** tab, and click the **Convert to Range** option. If you want others to be able to collaborate on your workbook, it needs to be saved in a shared location. ## Adding the Track Changes Buttons To access these options, you’ll need to add them to your Ribbon menu (unless your version of Excel includes them by default). Doing so is simple: - **Right-click** on the **Ribbon** menu. From the options available, select the **Customize the Ribbon** option. - On the resulting dialog screen, find the drop-down menu labelled **Choose commands** **from:** and select **All Commands**. In the other menu, select **Main Tabs**, and find **Review** in the list that appears. Click on the **+** next to **Review**, and then click the **New Group** button. - Right click on **New Group**, renaming it to “**Track Changes**.” - With “**Track Changes**” selected, find **Highlight Changes** and **Accept/Reject Changes** in the left-hand list. Click the **Add** button to add them to your “**Track Changes**” group. Once your **Highlight Changes button** has been added to the **Review** category of the **Ribbon menu**, **click** on the **Highlight Changes** button. A box will appear, where you should select both **Track changes while editing**… and **Highlight changes on screen**. Click **Okay** once you’ve done so. Once you’ve done this, any changes made to the spreadsheet will be marked with a small triangle in the corner of the cell to display the most recent change. ## Reviewing all Changes After everyone has contributed their input, you can choose to accept or reject the changes that have been made with the **Accept/Reject Changes** button. You’ll be asked to **Save the Workbook**, and once you have, the changes will be highlighted one by one with the option to **Select Changes to Accept or Reject**. All changes will be listed so that you can **Accept** them or **Reject** them accordingly. The cursor will automatically proceed to the next change for you to repeat the process. If there are multiple instances of a similar change (like all ampersands or percentages written out instead of the symbols used), you can use the **Accept All** button to mass update them. With any luck, we’ve helped make collaboration that much easier for you and your team members. For more tips like this, as well as best practices and other IT assistance, make sure you subscribe to our blog. Remember, our team is always available at PHONENUMBER for your IT needs. [ ](https://colemantechnologies.com/javascript:void(0);) [ ](https://colemantechnologies.com/javascript:void(0);) [ ](https://colemantechnologies.com/javascript:void(0);) Tags: [Microsoft Office](https://colemantechnologies.com/blog/tags/microsoft-office) [Software](https://colemantechnologies.com/blog/tags/software) [Tip of the Week](https://colemantechnologies.com/blog/tags/tip-of-the-week) [User Tips](https://colemantechnologies.com/blog/tags/user-tips) [×](https://colemantechnologies.com/javascript:void(0);) Stay Informed When you subscribe to the blog, we will send you an e-mail when there are new updates on the site so you wouldn't miss them. Your Name E-mail Address [ Today’s VoIP Platform is Completely Customizable ](https://colemantechnologies.com/blog/today-s-voip-platform-is-completely-customizable) [ CAPTCHA and Its Many Challenges ](https://colemantechnologies.com/blog/captcha-and-its-many-challenges) About the author [ ![Coleman Technologies Admin](https://colemantechnologies.com/media/com_easyblog/images/avatars/author.png) ](https://colemantechnologies.com/blog/blogger/darren-coleman) [Coleman Technologies Admin](https://colemantechnologies.com/blog/blogger/darren-coleman) [ ](https://colemantechnologies.com/blog/blogger/darren-coleman) Author's recent posts [More posts from author](https://colemantechnologies.com/blog/blogger/darren-coleman) [ Tuesday, 05 May 2026 Darren Coleman Featured in Boss Today on AI Literacy and Human Judgment ](https://colemantechnologies.com/blog/darren-coleman-bosstoday-ai-literacy) [ Monday, 06 April 2026 How Cloud IT Services Are Transforming Business Continuity ](https://colemantechnologies.com/blog/how-cloud-it-services-are-transforming-business-continuity) [ Monday, 06 April 2026 Darren Coleman Featured in USAWire on Why Businesses Need an AI Strategy ](https://colemantechnologies.com/news-a-events/darren-coleman-usawire-ai-strategy) ## Schema ```json { "@context": "https://schema.org", "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://colemantechnologies.com" }, { "@type": "ListItem", "position": 2, "name": "Blog", "item": "https://colemantechnologies.com/blog" }, { "@type": "ListItem", "position": 3, "name": "Coleman Technologies Admin", "item": "https://colemantechnologies.com/blog/blogger/darren-coleman" }, { "@type": "ListItem", "position": 4, "name": "Tip of the Week: Keeping Track of Changes Made in Excel", "item": "https://colemantechnologies.com/blog/tip-of-the-week-keeping-track-of-changes-made-in-excel" } ] } ```