Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Transfering excel data to word
Resolved · Low Priority · Version 2003
Andrea has attended:
Excel Introduction course
How do I get excel name & addresses to print out on word document.
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 2010Did you know the quickest and most simple way of working out the average or sum of a set of numbers? |
We'll call during UK business hours
Server loaded in 0.1 secs.