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

Using a Spreadsheet within a Word Document

Friday, March 18th, 2011 by | Filed Under: MS Excel, MS Office Help, MS Word
 
Loading...


MS Word: Using a Spreadsheet Within a Document

On more than one occasion, I’ve found that within a document I’ve needed to present data that really should be set up in Excel.

Don’t get me wrong, Word’s tables are great, but when it comes to calculations and numeric data displays, Excel wins hands down.

Some might ask why I don’t simply write the document within Excel so that the spreadsheet element is already there…

My reply would have to be “No way!” The word processing portion of my document will be much more polished and easier to assemble in Word.

No, I definitely want Excel capabilities inside Word, and not the other way around.

Fortunately, the ability to do just that is in Word. It’s just a matter of knowing where to find it.

Take a look on the Insert tab of the Ribbon, Table button.

See it at the bottom?

Yep, that says “Excel Spreadsheet

Choose it and you’ll see this inserted into your document at the current location of the cursor.

Instantly, you have everything right here inside of Word that you need to get the data presentation you want.

The Ribbon flipped over to the Excel Ribbon, you have scroll bars to move through the spreadsheet and even tabs for multiple sheets (granted only one would display at a time but you could hide information in the bottom one that’s used to create your display in the top one).

Changing the size of the displayed portion of your worksheet is as easy as dragging the handles located around it when the spreadsheet is active.

When you’re done and ready to return to Word, simply click outside of the spreadsheet.

Whatever you had displayed when you clicked out of the spreadsheet it what you’ll see so be sure to re-size and have Excel object showing exactly the information you need to display.

Need to edit the spreadsheet?

No problem. Double-click on the spreadsheet and it will open again giving you full access to edit as though you were using Excel instead of Word.

The data power of Excel is available to you without ever leaving Word… very nice!

~ April

Tags: , ,

4 Responses to “Using a Spreadsheet within a Word Document”

  1. Carolyn Gray says:

    How do you add an Excel spreadsheet to Word using version 2003?

  2. Jill says:

    SUPER SUPER TIP. . .I knew this once long ago, but totally forgot about it.
    Will be putting it to good use starting tomorrow.

    Thanks so much !!

  3. The Crink says:

    I have kinda done this with cut and paste with less than great results. This is great, I will start doing this right away, so it will stick in my mind. Thank you!

  4. David says:

    You can accomplish nearly the same thing in Word 2000 by choosing “Insert|Object” and then selecting Microsoft Excel Worksheet. Word 2003 probably has something similar.

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: