top of page

Improving Excel with Python (Day 5 of 5)

My starter scripts in January 2021:

Track changes in Excel

My most hated feature of Excel is tracked changes.

Tracked changes in Excel are presented in a separate tab, away from the data that has been changed, presenting challenges to any user who needs to trace back over the changes that have been made.

I explored creating a more intuitive display of tracked changes using cell comments to show a full audit trail of the changes made.

Here’s a snippet that logs the changes made in Excel by updating the cell comments with a time and the cell’s previous value.

This brings my short exploration into solving Excel problems with Python to a close.

But the possibilities are endless, so if you have ideas, please get in touch:)


Have a look at the full code I used, here:

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page