Highlighting Changes Made To A Workbook


This feature of Excel is designed to track changes made by users or yourself.

This function is primarily made to track changes made to workbooks by shared users on a network, so if you want to highlight the changes you have made only then there are are a couple of features you must also turn on— workbook sharing and change history.

On your Review Ribbon (2007) or for earlier versions of Excel…

1. Tools menu

2. Track changes

A dialog box appears- make sure the track changes while editing box is selected, select the highlight changes on screen option then click ok.

You are all ready to check your changes to your workbooks.

As you can see every change can be either seen by holding the cursor over the dialog box on the left or can be seen on the History Worksheet Tab at the bottom of the workbook.

As seen in the example above I have changed numerous cells. It contains great information as to the time and date, the sheet amended as well as the new value.- How Big Brother is that!?.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts