Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Fitting Excel Data into Word Document
I have an Excel file that's 45 lines. I copy the data into a Word document.
The Word document has about 5 lines at the top so the total should easily fit on 1 page but so far I can't get that to happen. I'm using Word 2007 and I don't believe Word has a "fit to page" option like Excel. So either I need to generate a bitmap image of the excel information and paste that in or perhaps someone could explain how I might do this. I've tried changing margins but there are always a couple of lines going onto page 2. Any help is appreciated. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Fitting Excel Data into Word Document
Word has a "shrink to fit" option in the Print Preview window.
dhstein wrote: I have an Excel file that's 45 lines. I copy the data into a Word document. The Word document has about 5 lines at the top so the total should easily fit on 1 page but so far I can't get that to happen. I'm using Word 2007 and I don't believe Word has a "fit to page" option like Excel. So either I need to generate a bitmap image of the excel information and paste that in or perhaps someone could explain how I might do this. I've tried changing margins but there are always a couple of lines going onto page 2. Any help is appreciated. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Fitting Excel Data into Word Document
I tried but got this message:
After several attempts Word was unable to shrink the document by one page "garfield-n-odie [MVP]" wrote: Word has a "shrink to fit" option in the Print Preview window. dhstein wrote: I have an Excel file that's 45 lines. I copy the data into a Word document. The Word document has about 5 lines at the top so the total should easily fit on 1 page but so far I can't get that to happen. I'm using Word 2007 and I don't believe Word has a "fit to page" option like Excel. So either I need to generate a bitmap image of the excel information and paste that in or perhaps someone could explain how I might do this. I've tried changing margins but there are always a couple of lines going onto page 2. Any help is appreciated. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Fitting Excel Data into Word Document
I just did it in Excel - thanks for the help.
"garfield-n-odie [MVP]" wrote: Word has a "shrink to fit" option in the Print Preview window. dhstein wrote: I have an Excel file that's 45 lines. I copy the data into a Word document. The Word document has about 5 lines at the top so the total should easily fit on 1 page but so far I can't get that to happen. I'm using Word 2007 and I don't believe Word has a "fit to page" option like Excel. So either I need to generate a bitmap image of the excel information and paste that in or perhaps someone could explain how I might do this. I've tried changing margins but there are always a couple of lines going onto page 2. Any help is appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from excel used in Word document | Microsoft Word Help | |||
Linking Excel Data in a Word Document | Microsoft Word Help | |||
Fitting a document | Microsoft Word Help | |||
Fitting a document | Microsoft Word Help | |||
Reference Excel data in a Word document | Microsoft Word Help |