importing excel spreadsheeting into word tables

[Barbara]

I work with people who insist on using Excel for text documents instead of
Word tables.

I'd like to import the data into a word table to show them how much more
convenient and easy it would be to use Word than Excel.

I've tried several ways to copy and paste rows or columns of data, as well
as the whole worksheet into a word table with limited success. I don't want
to spend hours correcting the document for demonstration purposes.

If you have any suggestions, I'd love to hear them

 

[Anne Troy]

You'd really have to tell us the problems you're having for us to offer up
solutions. A nicely formatted Excel workbook will copy over nicely into Word
tables. Alternatively, maybe you should let them keep their **** Excel and
use Mailmerge to layout the data?
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Barbara]

The excel "table is 7 columns across and about 50 rows deep. The problem I
believe lies with merging rows. When I copy the worksheet and paste special
(I've tried all the flavors of special) I get a teeny tiny graphic of the
page in the upper left hand corner of the word doc. I haven't tried
mailmerge, nor have I tried unmerging all the excel cells and then copying to
word and then deleting all the unnecessary cells. We're all on Wxp so the
double byte issues should no come into play (the doc is English and Japanese).

I'd leave it alone, but you can't print out the excel sheet without losing
some of the content in the cells. Everything can be read on the screen, but
in a meeting, everyone wants the papaer document in front of them, and that
is not possible at this point. Thanks!