Excel/Word

alexb · Apr 2nd, 2002, 02:39 AM

I need to copy a sheet in to Word but by cutting and pasting all the margins change and the four columns I am using fill about four pages. When I print from excel it fills two pages so I know it will fit into a two page word document. Is there a trick to make it cut and paste the same page dimensions as I have in print set up?

Anne Troy · Apr 2nd, 2002, 06:14 AM

Page setup in Word and Excel are completely different, so your theory that it should fit has loopholes.

When you copy and paste to Word, it pastes as a Word table. If you copy, then paste special as a picture, you may have more WYSIWYG behavior.

Jack in the UK · Apr 2nd, 2002, 11:09 AM

Hi Dreamboat our Word expert, i am not good to she you posting, love the site by the way, you know this develop and im sure that it wil be a fav of mine for tips...

have you sen TecNet???

Answer.. i have said many times if a VBA is needed why bother .. look in samples .xls this SHOULD be default in Office if LEGAL copy is installed and so there are all the office / office VBA needed from Excel..

Thank to Microsoft.. not the best code but thanks to MS.. not often i say that.

Apr 2nd, 2002, 06:14 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Page setup in Word and Excel are completely different, so your theory that it should fit has loopholes. When you copy and paste to Word, it pastes as a Word table. If you copy, then paste special as a picture, you may have more WYSIWYG behavior. __________________ ~Anne Troy

Apr 2nd, 2002, 11:09 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Dreamboat our Word expert, i am not good to she you posting, love the site by the way, you know this develop and im sure that it wil be a fav of mine for tips... have you sen TecNet??? Answer.. i have said many times if a VBA is needed why bother .. look in samples .xls this SHOULD be default in Office if LEGAL copy is installed and so there are all the office / office VBA needed from Excel.. Thank to Microsoft.. not the best code but thanks to MS.. not often i say that. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 2nd, 2002, 02:39 AM	#1
alexb New Member Join Date: Mar 2002 Posts: 17	I need to copy a sheet in to Word but by cutting and pasting all the margins change and the four columns I am using fill about four pages. When I print from excel it fills two pages so I know it will fit into a two page word document. Is there a trick to make it cut and paste the same page dimensions as I have in print set up?