Copy/paste from Excel to Word problems!

rmeyts · #5 06-14-2011, 08:20 AM

I came across this by dint of trial and error the other day. This allows me to copy Excel information into a Word table ending up in native Word format so it looks as good as the text in the rest of the document (but no links I am afraid):

1. Select/Copy your Excel range.

2. Paste into Word. This is the same as paste Special/HTML Format.

The pasted range will be much too big for the page, however this is the trick to make it fit (all the rest is done in Word):

3. Select a range starting just before the beginning of the range just pasted, ending just after the end of the range (i.e. select OUTSIDE the area that you have just pasted; do not start or end your selection inside what was the Excel data).

4. Now convert this selected area to a Table, as follows:

Table/Convert/Text to Table [note that you should only have the Text to table ... option, the other one being greyed out].

5. When the Convert Text to table box appears, just click OK (no need to make any changes).

As if by magic, the Excel table will now be formatted as a Table within Word, fitting into the normal Word margins, and breaking across pages as you would expect of a normal Word table.

The Excel cell layout will be preserved, but there won't be any links to the original workbook. However, all the text will be in native Word format, so that you can re-format if required.

Your Excel data will appear in a Word table that appears to have an extra (blank) row top & bottom, and an extra (blank) column left & right. Apart from the top row, they resist deletion, so you will need to 'remove' the Borders from within Borders and Shading (select from the first blank row of the table to the end, and then delete the borders; they will still show in grey but will not show up in print).

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy and paste not working	Ellie	Word	3	11-07-2013 02:23 PM
Word Copy Paste Problem...	haxmania1	Word	1	07-30-2009 06:49 AM
Copy & paste low resolution	worriedme	Drawing and Graphics	0	06-01-2009 03:05 AM
copy/paste charts from excel to word	bielak01	Excel	0	04-16-2009 02:27 AM
Copy and paste special	Dace	Excel	2	02-16-2009 12:18 PM