Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Move Cell Contents to a Text Box in MS Excel

Tuesday, June 22nd, 2010 by | Filed Under: MS Excel
 
Loading...



How many times have you found that you’ve put very important information buried in the center of an Excel worksheet?

Whatever the information is, it’s important and you need to present it well.

Is it information that can, or maybe should, be presented so that it stands out – font, text size, color, whatever you deem appropriate.

But all that is hard to do in the middle of a worksheet without creating problems with the way the whole thing looks. Besides, if it’s that important then the reader shouldn’t have to find it in the middle of a full page of data.

Of the many other things I can think of to present the data my personal choice would be a text box.

Wait, wait, before you protest that it would require manual updating every time that the information changes let me just say that if we do this right then every time the cell contents change then so does the text box!

Interested?

Yeah, me too… so let’s get right to the “how to” of the thing.

Obviously you’d already have the information somewhere on the worksheet, so we’ll officially start by inserting a text box.

Once the text box is placed, select it then click into the formula bar.

image

Begin, as always, with the =.

Now it’s time to enter the location of the cell with the important information – simply click on the cell and let Excel do the address insertion.

Hit the Enter key.

Voila! The text box is filled with your cell contents.

You’re now free to format the text box however you like with no repercussions to the worksheet layout – and that’s always a good thing!

~April

Leave a Reply


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: