transfer excel to word...format gone 2

[butchkmd]

I'm importing excel spread sheets into word document. When I look at the print preview or print the worksheet in excel it is one page...when I cut and paste, special paste, or import it it is any where from 4 to 36 pages!
What am I doing wrong?????


Thanks in advance

Matt

 

[Dreamboat]

When you just paste, Matt, it pastes as a Word table. If I were you, I'd try paste special--as a picture.

http://www.TheWordExpert.com

 

[butchkmd]

I did that I've tried quite a few of th options in the special paste as well. I can get it close but it hangs over the edges of the page and I can't size it.

 

[Dreamboat]

Can't resize it?? Sure you can. I think... Right-click and hit Format-Picture... or just grab the resize handle from the bottom, left-hand corner and drag toward the center of the picture.

http://www.TheWordExpert.com

 

[butchkmd]

I got the image on the form now everything fits thank you.
But the problem is that I can't type on the image. If I double click on the image the spread sheet activates and I'm back in Excel. I need the document to look like a word document and work like a word document. Is this possible?

 

[NSoulBri]

Whats wrong with simply, Insert/Object...Create from file/Browse. Don't you want the entire sheet? Bri

"Soul music is for life, not just christmas"

 

[butchkmd]

I do want the entire sheet but i need to have the sheet automaticly tab to the next cell when 1 character is entered into each cell. I found you can limit the number of chrts per cell but all it does is give you an error message when you hit enter. I looked at to recording a macro then adding an If statment to evaluate the contense of the cell but it doesn't move to the next cell.