You can come out of edit mode when you click outside the object window. It will open the spreadsheet in an Excel interface (felt like pure magic when I first used it). If you want to edit the table, simply double-click inside the object. So you can apply formulas and work on it as a regular excel table. Note: The inserted table is not a regular Word table. So you can go ahead and resize it as required. The size of the embedded object might not fit correctly to your Word doc’s margins. This will insert the copied cells into your Word doc.
INSERT FORMULA MS WORD ON MAC WINDOWS
This is made possible by the Windows OLE technology (Object Linking and Embedding).Įmbedding the object, rather than just pasting it, ensures that the object retains its original format. Inserting an Excel File into Word as an Embedded ObjectĪn alternative way to insert an Excel file into Word is by inserting it as an embedded object.Īn embedded object is an object that is created with one application and then embedded into a document that is created by another application.įor example when you embed an object or file created in Excel into a document created in Microsoft Word. If you want to take advantage of Excel formulas inside Word, then the next two methods might work better for you. So you cannot use Excel formulas in the table once it is pasted to Word
Place your cursor where you want to insert the Excel table.Open the Word file where you want to insert this data.Press CTRL+C to copy (or right-click on the selection and then click on Copy).Select the part of the Excel file that you want to insert into your Word file.
The method simply involves the following steps:
In fact, you have probably already used this technique plenty of times. It’s just like copy-pasting data from one sheet in Excel into another. This first copy-paste method is the easiest. Inserting an Excel File into Word by Simple Copy-Pasting
0 kommentar(er)
