From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,100 courses taught by industry experts.

Create shapes and text boxes with content linked to worksheet cells

Create shapes and text boxes with content linked to worksheet cells - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create shapes and text boxes with content linked to worksheet cells

“

- [Instructor] On this worksheet, we're seeing a number 2 of different shapes and most of the shapes 3 have some actual content in them. 4 Now, it's easy to create a shape 5 and type in information, whatever you want, 6 but you can also associate a shape with text data. 7 That also makes that relationship dynamic. 8 When cell content changes, 9 the object content changes as well. 10 The green oval that we're seeing just to the right 11 of the data here contains the January expense number. 12 If I change that January expense number to 50,000, 13 as soon as I press enter, this reacts. 14 Now, the process is fairly straightforward. 15 Let's create a new object. 16 We do this on the insert tab in the ribbon, 17 starting with illustrations and then shapes. 18 And there are many, many possibilities here, 19 about 200 of them. 20 Most of these shapes, 21 certainly not all of them like the lines, 22 most of these shapes…

Contents