Pasting from Excel to Word

  • Thread starter Thread starter CHIEF ADKINS
  • Start date Start date
C

CHIEF ADKINS

I have several columns (62) of numbers (vertically
aligned) on an Excel spreadsheet that I must transfer to
a Word document in row (62)format (horizonally). Is
there a way to do this without extensive cutting and
pasting? When I use "paste special" the numbers appear
on the word document vertically.
 
I figured out an alternate method that is a lot less
cumbersome.

First, I created a new blank excel worksheet.
Next, I highlighted and copied my 62 columns of numbers
from the original worksheet.

I then, on the new worksheet, selected paste special,
values & number format, and checked transpose. This
copied the columns in row format on the new worksheet.

I then linked my 62 rows on the Word document to the new
worksheet.

Thanks anyway for the help. You guys are good.
 
Back
Top