You’ll see that the inserted Excel data looks the same as in the previous section, but there’s a significant difference. The procedure to do this is identical to the one above, except in the Paste Special window you want to make sure to select the Paste Link checkbox. The best way to insert an Excel worksheet into a Word doc is by pasting it as a linked embedded object. Insert An Excel Worksheet As A Linked Object Cons: Doesn’t update with source data, and can’t edit table directly inside Word.

Pros: Fast and convenient, good for large tables, and conserves original formatting.It also gives you an “attached” Excel data file of the original data file in case you ever want to modify the data or add additional data to your pasted Excel object in Word. What is nice about this approach is that none of the original formatting gets changed during the conversion to a Microsoft Word table. You can use all of Excel’s functions and formatting features to make any changes.

When you double-click the object, Word opens the copied file for editing.

When you use an embedded object to paste Excel data, Word creates a copy of the original Excel file.

But any edits you make and save in that Excel file will update in your Word document. Keep in mind this is an entirely new Excel file (not the original). If you do want to edit the data, just double-click on the object and it will open the entire original spreadsheet inside Microsoft Excel. To find out more about using Word 2016, all in the trusted In Easy Steps style, click here.However, you can resize the entire object so that it fits inside the margins of your document. You can check at any time whether a piece of text is currently included in the Table of Contents. To do this, select the text then click the Add Text tool to see if it’s currently assigned to any particular level. To remove an item, select some text which is already in the Table of Contents, then click the Add Text button and select “Do Not Show in Table of Contents” The next time the Table of Contents is created or fully updated the new entry will appear Select some text which is not already in the Table of Contents, then click the Add Text button and choose a Level number. They also behave like hyperlinks: Ctrl + Click on any of these to jump straight to the relevant page Note that the entries generated in the Table of Contents reflect the heading structure in the main document. If you’re using Web view then the Table of Contents will be displayed with actual hyperlinks rather than page numbers as you can see to the right.

How to insert a table in word pad