Progress tracker with animated image in Excel - Excel Tips and Tricks

Progress tracker with animated image in Excel - Excel Tips and Tricks

Discover I can create a progress tracker with animated image in Excel. br I will not be using an animated gif in cell, but use logical IF to shuffle the image. I will be using checkbox to replace traditional progress bar for project tracking and habit tracking. Did I day this can be used for habit tracking too? br br Here are the steps as outlined on this video. br br Enable Developer Ribbon br 1) Right-click anywhere in the ribbon br 2) Customized the Ribbon... br 3) Check on Developer br 4) OK br br Add Checkboxes br 1) Developer ~ Controls br 2) Insert ~ Form Controls ~ Check Box br 3) Right-click ~ Edit Text br 4) Delete text br 5) Right-click ~ Format Control br 6) Cell Link A2 br 7) OK br 8) Repeat steps 2 to 7 for all rows br 9) Check all checkboxes br 10) Change cell font to white. br br I recently posted a video on how you can make an animated habit tracker using Google sheet like this. br But a few of my subscribers were requesting if I can do the same thing in Microsoft Office. br So... I just have to try it. And this is how you can do it. br br After that, we're going to place a check on every check box and change the font colour of the cell to white. br br Just note that your loader index boundary might be different than mine. br br In the next part we will finish off this tips and tricks... stay tuned.


User: RobertBarone

Views: 11

Uploaded: 2025-08-13

Duration: 02:33