Copy Paste each cell to a new page

eNGiNe · #6 01-20-2014, 12:55 AM

Quote:

Originally Posted by eNGiNe

What I did …

selected the single column in Excel
pasted it into Word – this gives a table
converted the table into text (Table tools, Layout, Convert to text)
selected all the text, applied a heading style with Page break before and text colour Automatic

This option does not use paste special, so the Excel colours are still there and you can use them to drive search/replace.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste Special: Copy and Paste Formatting Only?	tinfanide	Word	6	03-06-2013 12:21 AM
Copy and paste words on right side of page	Videolife	Word	3	01-26-2013 12:54 PM
Can't copy paste	irenasobolewska	Office	2	10-26-2012 05:09 PM
Find, copy and paste into a new page	jperez84	Word VBA	24	09-20-2012 11:34 AM
Copy - Paste between 2 tables	rod147	Excel	1	10-22-2009 08:21 PM