Using Excel in Word

Hi Friends!

Today’s tip is about using Excel in MS Word. Of course you can copy and paste an existing spreadsheet into a Word document, but you can also create a spreadsheet from scratch. As you may know Word tables don’t do calculations, so if you need to do calculations and you want the numbers to format correctly, insert an Excel “object.”

1.   In Word, click the Insert tab.

2.   Click on “Object”

3.   A menu box will open from which you will choose one of the Excel options. I selected the 2007, Binary workbook.

4.   Up pops an edit-ready worksheet, like this:

(I put those words in the example.)

When you click outside the table, it looks like this and cannot be modified as long as it looks this way:

To get back to editing your spreadsheet, just double-click inside the spreadsheet area.

Have fun with that!

Thanks for stopping by!

 

Advertisements

Leave a comment

Filed under MS Excel, MS Word

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s