ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy Excel Sheet into word (https://www.excelbanter.com/excel-discussion-misc-queries/59208-copy-excel-sheet-into-word.html)

Littlebear

Copy Excel Sheet into word
 
Someone needs an excel sheet copied into Word.

I tried File, Insert, but that doesn't seem to work. Not even sure if this
is the proper way to do this. (I'm getting Word cannot start the converter
Exel32.cnv)

Helpful hints anyone?

Thank you!

Littlebear

Copy Excel Sheet into word
 
Let me clarify. The Excel sheets needs to be copied into a multi-page Word
document, to become part of that text document.

"Littlebear" wrote:

Someone needs an excel sheet copied into Word.

I tried File, Insert, but that doesn't seem to work. Not even sure if this
is the proper way to do this. (I'm getting Word cannot start the converter
Exel32.cnv)

Helpful hints anyone?

Thank you!


John A

Copy Excel Sheet into word
 
1. Copy the Range of the spreadsheet you want to transfer.
2. Go to your Word document and place the cusor in the approximate area you
want the spreadsheet to go.
3. Select under the "Edit" menu, "Paste Special."
4. Highlight, "Microsoft Excel Worksheet Object." This will insert the
spreadsheet. If it looks okay, you don't need to do anything else. If you
want to move it around or resize it, go to the next step.
5. In your Word document, place your cusor on the spreadsheet box, which
will outline it.
6. Go to the Format menu and select "Object."
7. Click on the "Layout" tab.
8. Click on the box that best shows what you want the surrounding text to
do (you can always experiment with each by going back into this selection).
9. Click "OK"
10. When you go back to the document, you'll see you can move the box
around and also resize it by pulling one of the corners.

"Littlebear" wrote:

Let me clarify. The Excel sheets needs to be copied into a multi-page Word
document, to become part of that text document.

"Littlebear" wrote:

Someone needs an excel sheet copied into Word.

I tried File, Insert, but that doesn't seem to work. Not even sure if this
is the proper way to do this. (I'm getting Word cannot start the converter
Exel32.cnv)

Helpful hints anyone?

Thank you!


Littlebear

Copy Excel Sheet into word
 
Sweet.....! It worked, but the spread in Word appears shaded, although it
prints fine. Is this how it's supposed to appear?

Thanks John!

"John A" wrote:

1. Copy the Range of the spreadsheet you want to transfer.
2. Go to your Word document and place the cusor in the approximate area you
want the spreadsheet to go.
3. Select under the "Edit" menu, "Paste Special."
4. Highlight, "Microsoft Excel Worksheet Object." This will insert the
spreadsheet. If it looks okay, you don't need to do anything else. If you
want to move it around or resize it, go to the next step.
5. In your Word document, place your cusor on the spreadsheet box, which
will outline it.
6. Go to the Format menu and select "Object."
7. Click on the "Layout" tab.
8. Click on the box that best shows what you want the surrounding text to
do (you can always experiment with each by going back into this selection).
9. Click "OK"
10. When you go back to the document, you'll see you can move the box
around and also resize it by pulling one of the corners.

"Littlebear" wrote:

Let me clarify. The Excel sheets needs to be copied into a multi-page Word
document, to become part of that text document.

"Littlebear" wrote:

Someone needs an excel sheet copied into Word.

I tried File, Insert, but that doesn't seem to work. Not even sure if this
is the proper way to do this. (I'm getting Word cannot start the converter
Exel32.cnv)

Helpful hints anyone?

Thank you!


John A

Copy Excel Sheet into word
 
You're welcome, LB.

With regard to the shading, that seems odd. If you see there is some faint
shading when you print it, then you may have inadvertantly shaded the
worksheet when you brought it over. You can check by doing the following:

1. Click on the worksheet you inserted into your document (in Word)
2. Under the "Format" menu, choose "Object"
3. Click the "Color and Lines" tab.
4. The first section of this window says, "Color." The box to the right
should say "No Fill." If it doesn't (in which case it is filled by a color),
toggle the arrow to the right of this box and select "No Fill." If it
already says, "No Fill" then this isn't the problem.
5. Click the OK button.

Other than this, I'm not sure what the problem is. Hopefully if what I said
doesn't work, the shading won't bother you too much.

John

"Littlebear" wrote:

Sweet.....! It worked, but the spread in Word appears shaded, although it
prints fine. Is this how it's supposed to appear?

Thanks John!

"John A" wrote:

1. Copy the Range of the spreadsheet you want to transfer.
2. Go to your Word document and place the cusor in the approximate area you
want the spreadsheet to go.
3. Select under the "Edit" menu, "Paste Special."
4. Highlight, "Microsoft Excel Worksheet Object." This will insert the
spreadsheet. If it looks okay, you don't need to do anything else. If you
want to move it around or resize it, go to the next step.
5. In your Word document, place your cusor on the spreadsheet box, which
will outline it.
6. Go to the Format menu and select "Object."
7. Click on the "Layout" tab.
8. Click on the box that best shows what you want the surrounding text to
do (you can always experiment with each by going back into this selection).
9. Click "OK"
10. When you go back to the document, you'll see you can move the box
around and also resize it by pulling one of the corners.

"Littlebear" wrote:

Let me clarify. The Excel sheets needs to be copied into a multi-page Word
document, to become part of that text document.

"Littlebear" wrote:

Someone needs an excel sheet copied into Word.

I tried File, Insert, but that doesn't seem to work. Not even sure if this
is the proper way to do this. (I'm getting Word cannot start the converter
Exel32.cnv)

Helpful hints anyone?

Thank you!



All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com