• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Track Changes in Excel

April 27, 2021 by Andrew Childress
Track changes Excel

If you have a shared spreadsheet with multiple editors and you want retrace your own changes later. Here's how to use track changes in Excel.

Imagine that you have a shared spreadsheet with multiple editors. Or, you might want to retrace your own changes later on. Excel has a feature for this called track changes. Let’s learn how to use track changes in Microsoft Excel.

How to Install Track Changes in Excel

By default, the track changes command doesn’t display on Excel’s ribbon. But fortunately, it’s easy to add. To begin, go to the Excel dropdown in the far upper left corner, and click on it. Choose Preferences.

Track changes Excel

You’ll see the Excel Preferences window appear, with a variety of options on it. You’ll want to click Ribbon & Toolbar.

Excel track changes

In the right sidebar, underneath Customize the Ribbon, scroll down and click on the Review check to ensure it’s selected.

Install track changes Excel

Then, click on the + button underneath the list, and click on New Group from the dropdown. This creates a new group where you can add the Track Changes function.

Set up track changes Excel

On the left sidebar, under Choose Commands, select Main Tabs from the dropdown. Then, in the tree below, open Review > Changes > Track Changes (Legacy). Finally, click on the > arrow in the middle to add it to your group. Finally, click Save.

Track changes in Excel

How to Use Track Changes in Excel

On Excel’s Review tab, you’ll now see a Track Changes (Legacy) dropdown. To fully activate track changes, click on the dropdown and choose Highlight Changes. Finally, click on the Track Changes While Editing checkbox. Press OK.

Use track changes in Excel

Type in a few words and numbers somewhere in your spreadsheet. You’ll see a blue mark appear in the upper left corner of each. When you hover over this mark, you’ll see Excel display a quick summary of the changes you made, along with the name of the user making the changes.

This is a quick way to monitor and trace changes made to any spreadsheet in Excel.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Use fill handle ExcelFill Handle in Excel
Next Post:Name Box in ExcelName box sort Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top