Loose data during copy/paste from Excel 97 to Word 97

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

I have a worksheet which prints perfectly fine (1 sheet,
landscape) in Excel. I now want to copy this worksheet
into word (also Landscape). However, when pasting the
worksheet and decreasing the size so that it fits onto one
page the last 5 columns are missing. I tried to use
Insert - Object .... and Paste Special but not very
successful so far.

Any other ideas?
 
You've presumably used page break preview to set the breaks in Excel - go to page setup and check to see how much it has been scaled

In word create a document, make it landscape and set margins to minimum your printer will allow, then use paste special and insert as an excel worksheet. You can now right click, format object, size and put the same scale from excel into the scale size

Re
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Excel Worksheet into Word 2
Formatting of excel worksheets in word 2
Linking spreadsheets to Word 4
can i paste an excel worksheet into word and then rotate the item 2
Copying and Pasting Excel Tables into Word 1
Simple question on cutting and pasting into Word from Excel 1
Exel Table to Word Table 2
How do I size an embedded Excel OLE and keep it that way in Word 2

Back
Top