Copy Excel to Word.

Laa · May 11th, 2002, 09:26 AM

Hello, how to copy from excel to word w/ maintain all the format? i always try to copy from excel but whatever i copy are all not in format after i copy to word.Is there any way to solve the problem?

Anne Troy · May 11th, 2002, 10:13 AM

By default, it pastes as a Word table. Try Edit-Paste special, as a picture or Excel object or some other format. Try the different ones to find out what works best for you.

Mudface · May 11th, 2002, 02:18 PM

Be careful when pasting as an Excel object, though, unless you'd like the user to be able to edit charts etc. A couple of reports at work ended up over 3Mb in size (at less than 15 pages) due to this- pasting as a picture (not Bitmap) takes up the least space.

May 11th, 2002, 10:13 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	By default, it pastes as a Word table. Try Edit-Paste special, as a picture or Excel object or some other format. Try the different ones to find out what works best for you. __________________ ~Anne Troy

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

May 11th, 2002, 09:26 AM	#1
Laa New Member Join Date: May 2002 Posts: 1	Hello, how to copy from excel to word w/ maintain all the format? i always try to copy from excel but whatever i copy are all not in format after i copy to word.Is there any way to solve the problem?

May 11th, 2002, 02:18 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Be careful when pasting as an Excel object, though, unless you'd like the user to be able to edit charts etc. A couple of reports at work ended up over 3Mb in size (at less than 15 pages) due to this- pasting as a picture (not Bitmap) takes up the least space.