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.

How to copy word table to excel