Copying Information from excel

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

I have a spreadsheet that has several linked pages in it.
I want the final tally sheet to be in a format that the
reader can read but not have access to all the original
data. I have tried doing a copy/paste special and that
will not carry forward both the format and only the values
in excel.

When I tried it in Word, it cut off 3 of the columns and I
can't seem to get it so that all of them show. Excel is
in landscape 8 1/2 x 11 so in Word I tried changing the
settings to landscape/legal but that didn't work also.

I am using Office 97 - any help would be appreciated.

Thanks
 
Hi Janet

Here are two options.

Option 1.
In Excel, select the cells you want to display in the Word document. Edit >
Copy. In Word, Edit > Paste Special. Choose Picture (or Picture (Enhanced
Metafile)). Click the Paste Link button if you want to link to the original
Excel file. You have now brought in a *picture* of your spreadsheet. So you
can treat it like a picture. You can't edit it as a spreadsheet from within
Word. But if it's linked, you can make changes in the Excel file and they
will update in the Word file.

Because it's a picture, you can rotate it. In Word, click on the picture. On
the Drawing toolbar, click Draw > Rotate or Flip. Choose Flip Right. Drag it
into position, or, if you have a moderately recent version of Word,
right-click the picture, choose Format Picture > Layout > choose Inline with
Text (in earlier versions of Word you un-tick a box called "Floating").

You now have a picture that behaves essentially as one big character.

Option 2.
In Word, Insert > Break > Next Page. Click OK. Format > Page Setup. Choose
Landscape. In Excel, select the cells you want to display in the Word
document. Edit > Copy. In Word, Edit > Paste Special. Choose Picture etc etc
as in Option 1. After your picture, to get back to a portrait page, Insert >
Break >Next Page. Click OK. Format > Page Setup. Choose Portrait.

To understand what's going on in Option 2 using separate sections for
portrait and landscape pages, see Working with sections
http://www.mvps.org/word/FAQs/Formatting/WorkWithSections.htm

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 
Back
Top