E-Mail:

Importing Excel Data into Word 2002

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. From the Edit menu, click Copy.
  5. Switch to your Word document.
  6. Place the insertion point where you want the data.
  7. From the Edit menu, click Paste.

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

2 Comments

I hope you can help me with a problem merging an Excel spreadsheet into my Word master document which has the merge fields.

One column of has numbers, ie 0000 but one shown as A0000 merges as just 0

Some cells in another column are shown as 1,394.00 - 8% which when merged come out as 1239.08

There is also wording “20c in every $ incl allowances” which doesn’t convert either.

Alison, If you save your excel sheet as a Text Tab Delimeted and then mail merge it. The numbers should come out oK

What Do You Think?

 

Want to Start a Blog Here for Free?

Are you an expert in one subject or another? If your goal is to help others and dispense hard-earned information back to the community, stake a claim on your very own Lockergnome blog today! You can write about anything - no matter the topic. Sign-up to start blogging!

Favorite - Oct 10, 2008

Scour

Download, Freeware - Oct 9, 2008

CurrPorts v1.51

Download, Freeware - Oct 6, 2008

AudioGrail v6.13.2.158

Download, Freeware - Oct 3, 2008

SniffPass v1.07

83 queries / 0.808 seconds.