Word and Ecel

Cassa

New Member
Joined
Sep 2, 2002
Messages
3
This question will be long winded so please bare with me.
I am trying to combine excel spreadsheets and worksheets into a word document. Word has to be in portrait and excel in landscape and portrait.
I have no problem copying and pasting the excel files. The big problem is I get extra pages when I copy the excel files over into word. Another problem is that if I change the excel pages into landscape once I have them in the word document all the pages change to landscape. Another problem is I cannot centre the excel pages in the word report.
I hope someone will be able to set me on the right path to correcting these problems.
Cassa.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Not really my strong suit, but I believe you will have to use section breaks to orientate the pages in Word from Portrait to Landscape etc. Another solution might be to use Office Binder to combine Word and Excel Files into one entity. Then each can be orientated as needed, but all printed as one. Just an idea. It's been a long time since I worked with stuff like that.
 

Cassa

New Member
Joined
Sep 2, 2002
Messages
3
Thank you for your reply as I will try anything before I go crazy.
Cassa.
 

Cassa

New Member
Joined
Sep 2, 2002
Messages
3
I do not have the programme Office Binder. Can I download this programme or do I buy it.
Thank you
Cassa.
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
I think it depends on which version of Office you have. I have heard it is not available for XP. For 97 and 2000, it comes part of the Standard Office Edition, but it is not on the standard install. It needs to be selected during installation. You will have to either reinstall Office and select Binder or have your IT people acquire it for you. Check out the MS web site for more info
 

Forum statistics

Threads
1,143,640
Messages
5,719,984
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top