From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Insert a text box or shape and link a cell's content to it

Insert a text box or shape and link a cell's content to it - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Insert a text box or shape and link a cell's content to it

“

- [Narrator] On this worksheet 2 there're two shapes off to the right. 3 We've got an oval here and also a hexagon. 4 And then what appears to be a free floating number. 5 And if you look at some of the entries over 6 in columns B and C, 7 you can see that they somehow appear to be related. 8 Now these entries could've been typed, but they're not. 9 If I click the oval, look in the formula bar. 10 What do we see equal C2. 11 Click the hexagon to the right. What do we see? 12 B3 and sure enough, as I click this number right here, 13 this free floating 45,618, click this, 14 we see in the formula bar equal B2. 15 When you create shapes, 16 you can associate them with a given cell. 17 Now let's create a shape, insert tab. 18 That's where these two shapes are created. 19 Shapes is the option here. 20 I'm going to choose oval. 21 Now when you create an oval, it could be wide, 22 it could be tall, it could be anything…

Contents