[access-uk] Re: Help with exporting info from Excel to word
- From: "Peter Bentley" <bentleypdlists@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 12 Oct 2011 16:37:58 +0100
Thanks again John. Very clear.
Peter
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
John Gregory
Sent: 12 October 2011 16:12
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Help with exporting info from Excel to word
Hi Peter,
Just realised that the instructions below may be more applicable to Office
2003, but still works in 2010. However, just for clarification in 2010:
1. select the cells in Excel that you want to transfer to Word, hold down
'control' and press 'C' to copy the selection;
2. Go to the point in Word where you want the data to appear and hold down
'control' and press 'V' to paste the data;
3. Highlight the data pasted into Word and press F6 until you get to the
ribbon Bar;
4. Select the 'Home' tab and press the down arrow key once to 'Clipboard'
and then press the right arrow key to open the submenu;
5. Press the spacebar on the 'paste split button' option which will open
paste options;
6. Select the option you want such as 'keep source formatting', 'text only'
etc - note that you need to use the right arrow key to navigate these
options - presse the spacebar on the option you want and Word will format as
necessary.
Cheers.
John.
Hope the below helps.
Microsoft Excel and Microsoft Word are part of a software suite that is
designed to work together with ease. Because of this, the only method needed
to import data from Excel to Word is to cut and paste the data you want to
transfer. This allows you to be selective about what data is moved and what
is left behind, which can save a lot of time after a transfer has been made.
Difficulty:
Moderately Easy
Instructions
1.
* 1
Select the data in Excel you want to import into Word. Click the "Copy"
button on the toolbar. You can also right click on the selected data and
click "Copy" on the pop-up menu.
* 2
Select the location in your Word document to enter the copied data. Click
the "Paste" icon on the toolbar or right click and select "Paste" from the
pop-up menu.
* 3
Click the "Paste Options" icon that appears in the lower right-hand of the
pasted table. There are several selections and combinations that can be made
here. The option "Link to Excel" will create a link to the original Excel
spreadsheet so whenever the spreadsheet is updated, the Word document
updates automatically. If you want to keep the formatting and fonts from the
original Excel spreadsheet, select an option that says "Keep Source
Formatting." If you want your table to match the style of your Word
document, select "Match Destination Table Style." Finally, if you just want
the contents of the cells without any table formatting, select "Keep Text
Only."
* 4
Adjust the formatting of the new table to meet your needs.
By Grant McKenzie, eHow Contributor. extract downloaded from
http://www.ehow.com/how_4828659_import-excel-ms-word.html on wednesday, 12
October 2011.
John.
Other related posts:
