What happens when you double-click an excel worksheet that is embedded in a word document?

Hi Terry:

I have not got Excel here at the moment to try, so do this for me:

1) Use Format>Object>Size to set the Size to 100 per cent. Does that fix
it?

2) Double-click the object, add and remove a space from one of the cells,
then close it. Did that fix it?

3) The object is actually encased in a Text Box. There are two frames: one
for the object, the other for the text box.

If you click, then click again, slowly, the selection rectangle willslightly change its appearance. When that happens, try dragging again.It's damned difficult to get this to work: the first click selects theobject, the second click selects the frame. In Word X, it's nearly

impossible to see the difference.

Hope this helps

This responds to article <>,
from "T Farrell" <> on 11/2/03 4:29 PM:

-- All Spam and attachments blocked by Microsoft Entourage for Mac OS X. Please

post replies to the newsgroup to maintain the thread.

John McGhie, Microsoft MVP: Word for Macintosh and Word for Windows
Consultant Technical Writer <>
+61 4 1209 1410; Sydney, Australia: GMT + 10 hrs

Sometimes, you wish to include the data on an Excel spreadsheet in your Microsoft Word document. There are a couple of ways to do this, depending upon whether you want to keep a connection with the source Excel sheet. Let’s take a look.

What’s the Difference Between Linking and Embedding?

You really have three alternatives for consisting of a spreadsheet in a Word document. The very first is by merely copying that information from the spreadsheet, and then pasting it into the target document. For the many part, this just works with truly simple data because that data just ends up being a basic table or set of columns in Word (depending upon the paste choice you choose).

While that can be beneficial often, your other two options– connecting and embedding– are much more powerful, and are what we’re going to reveal you how to do in this short article. Both are pretty comparable, in that you wind up placing a real Excel spreadsheet in your target document. It will look like an Excel sheet, and you can utilize Excel’s tools to control it. The difference can be found in how these 2 choices treat their connection to that initial Excel spreadsheet:

There are advantages to both approaches, obviously. One advantage of connecting a document (besides maintaining the connection) is that it keeps your Word file’s file size down, due to the fact that the data is primarily still kept in the Excel sheet and only displayed in Word. One downside is that the initial spreadsheet file requires to stay in the very same area. If it does not, you’ll need to link it once again. And since it relies on the link to the initial spreadsheet, it’s not so useful if you require to disperse the file to individuals who do not have access to that place.

Embedding a file, on the other hand, increases the size of your Word file, since all that Excel information is really embedded into the Word file. There are some distinct advantages to embedding, however. For example, if you’re dispersing that file to people who might not have access to the initial Excel sheet, or if the file needs to reveal that Excel sheet at a specific time (rather than getting updated), embedding (and breaking the connection to the initial sheet) makes more sense.

So, with all that in mind, let’s take a look at how to link and embed an Excel Sheet in Microsoft Word.

How to Link or Embed an Excel Worksheet in Microsoft Word

Connecting or embedding an Excel worksheet into a Word is really quite straightforward, and the procedure for doing either is nearly similar. Start by opening both the Excel worksheet and the Word file you want to modify at the very same time.

In Excel, choose the cells you wish to link or embed. If you wish to connect or embed the entire worksheet, click on the box at the point of the rows and columns in the leading left-hand corner to choose the entire sheet.

Copy those cells by pushing CTRL+C in Windows or Command+C in macOS. You can also right-click any selected cell, and after that choose the “Copy” alternative on the context menu.

Now, switch to your Word file and click to put the insertion point where you would like the linked or embedded material to go. On Home tab of the Ribbon, click the down arrow below the “Paste” button, and then select the “Paste Special” command from the dropdown menu.

This opens the Paste Special window. And it’s here where you’ll discover the only functional various in the procedures of connecting or embedding a file.

If you wish to embed your spreadsheet, choose the “Paste” alternative over left wing. If you wish to link your spreadsheet, select the “Paste Link” alternative rather. Seriously, that’s it. This procedure is otherwise identical.

Whichever option you select, you’ll next choose the “Microsoft Excel Worksheet Object” in the box to the right, and then click the “OKAY” button.

And you’ll see your Excel sheet (or the cells you picked) in your Word document.

If you connected the Excel data, you can’t modify it straight in Word, however you can double-click anywhere on it to open the initial spreadsheet file. And any updates you make to that initial spreadsheet are then shown in your Word file.

If you embedded the Excel data, you can modify it straight in Word. Double-click anywhere in the spreadsheet and you’ll stay in the same Word window, but the Word Ribbon gets replaced by the Excel Ribbon and you can access all the Excel functionality. It’s sort of cool.

And when you wish to stop modifying the spreadsheet and go back to your Word controls, simply click anywhere outside the spreadsheet.

Note: If you working on a Word file and want to include a spreadsheet that you have not produced yet, you can. You can actually insert an Excel Spreadsheet right from the Table dropdown menu on the Ribbon.

            You can easily insert an Excel worksheet into a Word document to harness the power of Excel within Word. This helps Word users who like creating worksheets and performing calculations in Microsoft Excel. To insert an Excel worksheet into a Word document, you must have both Microsoft Word and Microsoft Excel installed on your computer as part of the same Microsoft Office installation. After you insert an Excel worksheet into a Word document, you can then edit the information in the worksheet using the Excel interface. However, it displays the data in the Word document as if it is a table.

            To insert an Excel worksheet into a Word document, place the insertion marker into the document location where you want to show the worksheet data. Then click the “Table” button in the “Tables” button group on the “Insert” tab of the Ribbon. Then click the “Excel Spreadsheet” command in the button’s drop-down menu. Doing this then inserts an Excel worksheet object into that location in the document.

Insert an Excel Worksheet into a Word Document – Instructions: A picture of a user inserting an Excel spreadsheet into a Word document.

            At that point, you are working within the Excel interface. Edit the contents of the cells in the Excel worksheet area. Also, apply all formatting to the cells in Excel, as you cannot make any formatting changes in Word.

            Note that the embedded Excel worksheet object has a dashed border around it. Only the information shown in this area appears in the document. To resize this display area to increase the data shown or remove extra cells from appearing, place your mouse pointer over the small black resizing squares that appear around the perimeter of the embedded worksheet object until your mouse pointer turns into a double-pointed arrow. Then click and drag to increase or decrease the size of the worksheet area that appears in the document. After entering the worksheet data and resizing its display, then click into the document area. Doing this then changes the display of the worksheet to a table.

How to Edit an Embedded Excel Worksheet in a Word Document

            To edit its contents again in the future or to change its display size, you must return to editing mode. To return to editing mode, double-click the embedded Excel worksheet object in the document. It then switches back to Excel so you can make the necessary changes. Then click back into the document after editing it to change it back into an embedded table within Word.

How to Delete an Embedded Excel Worksheet in a Word Document

            To delete an embedded Excel worksheet object in your document, simply click it to select it. Then press the “Delete” or “Del” key on your keyboard to delete the Excel worksheet.

Insert an Excel Worksheet into a Word Document: Instructions

Instructions on How to Insert an Excel Worksheet into a Word Document

1. To insert an Excel worksheet into a Word document, place the insertion marker into the document location where you want to show the worksheet data.
2. Then click the “Table” button in the “Tables” button group on the “Insert” tab of the Ribbon.
3. Then click the “Excel Spreadsheet” command in the button’s drop-down menu.
4. Enter the information to display into the Excel worksheet area.
5. Also, apply all formatting to the cells in Excel, as you cannot make any formatting changes in Word.
6. To resize the display area, place your mouse pointer over the small black resizing squares that appear around the perimeter of the embedded worksheet object until your mouse pointer turns into a double-pointed arrow.
7. Then click and drag to increase or decrease the size of the worksheet area that appears in the document.
8. To change the display of the Excel worksheet into a Word table when finished, click into the blank document area in Word.

Instructions on How to Edit an Embedded Excel Worksheet in a Word Document

1. To edit an embedded Excel worksheet’s contents or resize in the future in Word, you must return to editing mode.
2. You can do this by double-clicking the embedded Excel worksheet object in the document to switch back to Excel.
3. Then make the necessary changes.
4. To change it back into an embedded table in Word when finished, click back into the document.

Instructions on How to Delete an Embedded Excel Worksheet in a Word Document

1. To delete an embedded Excel worksheet object in your document, click it to select it.
2. Then press the “Delete” or “Del” key on your keyboard to delete the Excel worksheet.

Insert an Excel Worksheet into a Word Document: Video Lesson

            The following video lesson, titled “Inserting a Microsoft Excel Worksheet,” shows you how to insert an Excel worksheet into a Word document. This video lesson is from our complete Word tutorial, titled “Mastering Word Made Easy v.2019 and 365.”