Ever find yourself either retyping or copying and pasting information from an Excel worksheet into a text box or an AutoShape?
Maybe you need that data stated in a bold way, so it’s been put into a text box or an AutoShape to grab everyone’s attention.
Of course, I’ve got to ask. What happens when the data changes?
Do you then go back into the AutoShape or text box and fix the data in there too?
Tired of doing the double editing?
Yeah, I would be too, so here’s a quick tip on linking the text box or AutoShape to the cell.
The benefit, you ask?
Well, with the direct link to the cell containing the data, a change in the cell is automatically updated in the text box or the AutoShape. No more duplicate efforts.
Interested in the “how to”?
Yep, I was too, so let’s take a look.
- First, you’ll have to draw the text box or shape you intend to use.
- Your next step depends upon what type of object you have:
- For a shape you’ll need to right-click on it and choose Add Text from the menu. You can then click into the formula bar and type an equal sign (=).
- Since a text box is ready to go for text simply click into the formula bar and type your equal sign (=).
- Next, click the cell that contains your data.
- Finish by hitting the Enter key.
Voila! The information from the cell is now displayed in the text box or shape. You can proceed with formatting to fit your needs.
The best thing about all this?
No more duplicate work for you! Simply update the cell and the text box or AutoShape is fed the new information automatically!