Moving word documents into excel

[Deidra]

I'm having trouble moving a word document into excel. The problem that i'm having is when i move the document to excel, some of it is not showing up on the spreedsheet. Almost all the information is all moved to the left side of the page. I'm i doing something wrong or do i have to make the adjustments my self. Please help.

 

[Debra Dalgleish]

How are you moving the Word document into Excel?

You can choose Insert>Object, and on the 'Create from File' tab, select
a Word document.
This would display the first page in the Word document.

 

[Deidra]

I just realized i have another problem. What i'm trying to do is move an invoice into excel. The way im doing is that i'm selecting the whole table in word and copying it. Then i would go and paste it in excel, but i think i might be doing something wrong. Do you have a better suggestion? Aslo when i went back to the document in excel, the page was off the print margins. Can you help me?

 

[Debra Dalgleish]

After you paste the table into Excel, you may have to reformat it.

Select all the cells in the table, and choose Format>Cells
On the Alignment tab, for Vertical, choose Top
Add a check mark to the 'Wrap text' box
Click OK

Adjust the column widths, if necessary

To ensure that the invoice prints on one page:
Choose File>Page Setup
On the Page tab, select 'Fit to 1 page wide by 1 page tall'