Hi Terry,
#1 is probably because your Excel workbook contains many 'in-use' but empty rows after the data ends. Open it and press Ctrl-End. That will take you to the last active row. Delete all rows from there to the last data row, then save & close the workbook.
#2 is probably a page setup issue, to do with paper sizes and/or margins.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|