Pasting Spreadsheet into Word

[Marianne]

I would like to paste a spreadsheet into a Word doc for a report. I tried
doing it with copy/paste, but the lines show. Is it possible? Thank you.

 

[Dave Peterson]

Does this mean that you like the pasted table, just don't like the borders?

If that's what you mean, you can click in a cell in that table (in MSWord) and
then Table|Hide gridlines.

If that's not what you mean, you may want to explain.

 

[Marianne]

Actually, it's a balance sheet that I want to include in a report in Word.
When I copy the data from the spreadsheet and paste it into the Word doc, it
goes in fine, but there are dotted lines where the grid liines would be
normally. Can they be removed? I have Office 2007 and do not see what you
suggest. thanks

 

[Dave Peterson]

I used xl2003 and MSWord 2003 for that last post.

Are you sure those dotted lines are gridlines? Could they be borders that
you've applied to the range in Excel?

Anyway, when I selected the cells in the table (in MSWord), I could see a "Table
Tools" on the title bar.

Clicking that gave me the option to add/remove borders (on the right hand side
of the table styles group.

Actually, it's a balance sheet that I want to include in a report in Word.
When I copy the data from the spreadsheet and paste it into the Word doc, it
goes in fine, but there are dotted lines where the grid liines would be
normally. Can they be removed? I have Office 2007 and do not see what you
suggest. thanks

 

[Marianne]

I was able to remove the grid lines in Excel and then again in Word. Do you
know how I can shrink the text to fit one page? Right now, it spills onto a
second page. How can I make it smaller to fit one page? thanks

 

[Dave Peterson]

In word or excel?

I'm guessing MSWord...I would think you'd have to change the font size or
margins.

If that's not it and you don't get any better answers, you may want to ask in an
MSWord forum. Remember to include the version of Office that you're using.

I was able to remove the grid lines in Excel and then again in Word. Do you
know how I can shrink the text to fit one page? Right now, it spills onto a
second page. How can I make it smaller to fit one page? thanks

 

[Marianne]

Thanks. It would be Word. In Excel there is a feature in Page Layout to
size it to fit by a percentage. I was able to get an entire spreadsheet on
one page, but not on one page of a Word doc. If I mess with the font or
margins, I may mess up the formatting of the spreadsheet in Word.-
Marianne

 

[Dave Peterson]

I don't have any other suggestions.

Thanks. It would be Word. In Excel there is a feature in Page Layout to
size it to fit by a percentage. I was able to get an entire spreadsheet on
one page, but not on one page of a Word doc. If I mess with the font or
margins, I may mess up the formatting of the spreadsheet in Word.-
Marianne

In word or excel?

I'm guessing MSWord...I would think you'd have to change the font size or
margins.

If that's not it and you don't get any better answers, you may want to ask in an
MSWord forum. Remember to include the version of Office that you're using.