transfering excel data word

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Transfering excel data to word

Transfering excel data to word

resolvedResolved · Low Priority · Version 2003

Andrea has attended:
Excel Introduction course

Transfering excel data to word

How do I get excel name & addresses to print out on word document.

RE: transfering excel data to word

Hi Andrea

Thank you for your question and welcome to the forum.

If you are transferring a single address from Excel into a Word document, this can be done by copying and pasting from Excel into Word.

To do this:
1. Select the name and address in Excel, and copy.
2. In the Word document, paste the name and address. A little smart tag with a clipboard icon on it will appear at the bottom right of what you have pasted.
3. Click on the Smart Tag and select the Keep Text Only option. This will remove the Excel data from the table format that it is pasted in to begin with.

If you are looking to transfer addresses for a mass mailing, then use the Mail Merge wizard in Word (Tools - Letters and Mailings - Mail Merge).

Kind regards
Amanda


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.1 secs.