Press Ctrl-V, click a cell, and press Enter to paste the data into the worksheet. A blank worksheet will be added to the document, and the Excel toolbar will be visible at the top of the Word window. To embed the worksheet, copy it in Excel as described above, click in the Word file where you want the worksheet to appear, and choose Insert > Object > Microsoft Office Excel Worksheet in Word 2003, or click the Insert tab in Word 2007's ribbon, and choose Object > Object > Microsoft Office Excel Worksheet.
Unfortunately, the Word file will be huge and preserving the original formatting can be a problem.
Choose Paste Special > Picture (Windows Metafile) to place an image of your worksheet in a Word document.Įmbed the worksheet in the Word file: At first, this approach would appear to make the most sense, since the result is a fully functioning worksheet in the Word document. The worksheet appears just as it looked in Excel, but you can't make any changes to the data, though you can move, resize, and otherwise alter the resulting image just as you would any other image in Word. In both versions, select Picture (Windows Metafile), and click OK. But instead of pressing Ctrl-V to paste the cells, click the place in the Word document that you want the worksheet to appear, and in Word 2003 click Edit > Paste Special, or in Word 2007 click the Paste button under the Home tab, and choose Paste Special. Paste the worksheet as an image: Just as with the method above, you start by selecting the cells you want to add to Word, pressing Ctrl-C to copy them, and opening the target Word file. Also, if you want to perform Excel functions in the Word version, you'll have to make the changes in the Excel version and then reinsert the data as a new Word table. While this is the simplest and most common way to move data between the two apps, it frequently requires that you reformat some cells, rows, or columns to reproduce the worksheet's appearance in Excel. Here are the advantages and disadvantages of the various ways to add Excel data to a Word document, starting with the simplest.Ĭopy the cells and paste them as a Word table: If your Excel worksheet is formatted simply, and you won't need any of its formulas or functions to be active in the Word file, simply select the cells, press Ctrl-C, open the Word document, and press Ctrl-V to paste it as a Word table.
If you can alter the data, either the formatting is a mess, or the resulting Word document is huge. Whenever you move data from Microsoft Excel to its Office mate Word, it seems there's always a compromise involved: If the formatting makes the transition intact, then changing the data either causes problems or simply can't be done.
0 kommentar(er)
