Your IT Support Experts

We partner with many types of businesses in the area, and strive to eliminate IT issues before they cause expensive downtime, so you can continue to drive your business forward. Our dedicated staff loves seeing our clients succeed. Your success is our success, and as you grow, we grow.

Home

About Us

IT Services

Knowledge Base

Blog

Contact Us

Support

01202 835880

Free Consultation

Interested in seeing what we can do for your business? Contact us to see how we can help you! Sign Up Today

Oh-Tech Blog

Tip of the Week: Setting Up Excel to Track Changes

Tip of the Week: Setting Up Excel to Track Changes

Today’s software solutions are hugely benefited by the collaborative capabilities that are now included in them, but this is not to say that there isn’t the potential for confusion as people make changes to documents. Some software lets you track these changes, which is particularly useful in particularly dense applications like Microsoft Excel.

For this week’s tip, we’ll show you how you can easily set Excel up to keep track of any changes that your collaborators have made. Fair warning, this will involve a little bit of meddling in your menu options, so don’t hesitate to ask someone for help if it would make you feel more comfortable.

It is also important to take note that the Track Changes function will not work in a spreadsheet that contains tables, unless the table is converted to a range. To do so, simply select the table, and in the Design tab, click Convert to Range.

Furthermore, other users can only collaborate on Excel workbooks that have been saved to a shared location, so make sure that your files are saved in the right spots so that others are able to access them.

Adding the Buttons to Track Changes

First, you need to have an easy way to access these options, so it makes sense to add them to your Ribbon menu if need be. Some versions include these options by default, but some don’t. If it isn’t already there, make sure you add the button to the menu like so:

  • Right-click on the Ribbon menu and select the Customize the Ribbon option.
  • On the dialog screen that appears, locate the Choose commands from: drop-down menu, and select All Commands. The other menu should be set to Main Tabs, which means you’ll be able to find Review in the list. Click on the + next to Review, and then click the New Group button.
  • Right click on your New Group and rename it to “Track Changes.”
  • With “Track Changes” selected, find Highlight Changes and Accept/Reject Changes in the left-hand list and click the Add button to add them to your “Track Changes” group.

Once it has been added to the Ribbon menu under the Review category, you’ll need to configure your Highlight Changes button. Click on it, and in the box that appears, select both Track changes while editing… and Highlight changes on screen. Click Okay.

All the changes made on the spreadsheet by anyone will be annotated with a small triangle in the corner of the cell, displaying the most recent change.

Reviewing Changes

Once everyone has had their say and the time comes to pass or veto the changes made, click the Accept/Reject Changes button. You’ll be prompted to Save the Workbook, and once you do that, the spreadsheet will display with the first edited cell highlighted and another dialog box labeled Select Changes to Accept or Reject.

All changes made will be listed, allowing you to pick the best option and click Accept, or Reject if none of the options improve anything. The cursor will move to the next cell to review, and you can repeat the process. If multiple cells were changed in the same way (as when all uses of “&” needed to be changed to “and” or percentages needed to be written out as such), the Accept All button will make the needed changes.

Hopefully, this will help make collaboration a simpler process for you and your team. For more tips and best practices, make sure you subscribe to our blog, or give our team a call at 01202 835880 for in-depth IT assistance.

Do You Need to Extend Your Wireless Network?
IT Help Desk and Its Business Benefits
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Monday, October 26, 2020

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://oh-tech.co.uk/

We Provide Managed IT Support Services for Businesses In:

  • Bournemouth 
  • Poole
  • Christchurch
  • Ringwood
  • Salisbury
  • Dorchester
  • Southampton
  • Portsmouth

And all throughout the UK

News & Updates

COVID-19 is still a factor that businesses need to consider, especially in terms of their continued operations. With major adjustments required to stay open, many small and medium-sized businesses will need to accept the situation their business is in and implement changes. Fortunately, research that Salesforce summarized in their fourth Small & Medium Business Trends Report suggests that this is happening.

Contact Us

Learn more about what Oh-Tech can do for your business.

Oh-Tech
30E Chalwyn Industrial Estate
Poole, BH12 4PE

Terms & Conditions