E-Mail:
Get our new Windows 7 eBook (PDF) for $7 with 70+ Tips. Download Now!

Import Excel 2007 Data Into Word

  • No Related Post

One of the most common questions I hear when doing Office training is “How do I import data from Excel into my document?” Well there are a few different ways in which you can import data from Excel. The method you use will depend on whether or not you want the Excel data to retain its functionality in Word.

If you want, you can simply copy and paste your data into Word. When you do this, all the Excel data is converted into a Word table. So the Excel data does not retain any of its functionality once it’s pasted into word.

To perform this simple replication of data, use the steps outlined below:

  1. Open your Word document.
  2. Open your Excel spreadsheet.
  3. Within Excel, select the cells you want to copy into Word.
  4. On the Home tab, in the Clipboard group, click Copy.
  5. Switch to your Word document.
  6. Place the insertion point where you want the data.
  7. Press CTRL + V.

You can then modify the data in the table as you would any other Word table.

[tags]word, microsoft office, document, doc, excel[/tags]

5 Comments

how to get rid of the excel formatting, if the text in excel has been formatted with colors like grey color, bold, underline, etc, i used paste special… unformatted text and it would then lose the table format, there is no option to just impot/copy paste an excel table as plain word table with no formatting.

Thanks, now how do I import it AND retain some functionality?

This only works (any import it seems) as long as the document is not more than one page long. Otherwise you have to copy and paste one page at a time. Maybe there is an easier way, but MS Help and Googling around doesn’t seem to bring in the answer.

I believe the question asked about IMPORTING, not cutting and pasting. I’m still looking for the importing directions.

It does appear that we have lost an important feature, e.g. create a flow chart in excel, import whole file into word.

What Do You Think?

 
39 queries / 0.641 seconds.