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

תגובות


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page