- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

From Excel to Text box or Autoshape

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.

Good idea.

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.

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!

~ April