You might already use textboxes in Microsoft Excel—and they’re great for hovering over parts of a spreadsheet, using as callouts, and inserting whatever type of formatting you want. But did you know they can also auto-update based on text somewhere else in the worksheet? Yes, it’s true!
In this hands-on tutorial, I’ll show you how to insert a textbox and then set it up to pull text from another call in the worksheet. That means when the cell updates, so does your textbox. Like dynamic magic!
You might also enjoy other videos in my Excel playlist: https://youtube.com/playlist?list=PLwyXYwu8kL0z94yMKiX89nbwq6rxT4t7v
00:00 – Overviewing the completed worksheet with dynamic textboxes in Microsoft Excel
00:49 – Inserting textboxes
01:18 – Setting up a textbox to pull in data dynamically
02:19 – Inserting the second and third textboxes and making them auto-update
