Excel 2013 worksheet inserted as an object into a MS Word 2013 - Showing too many blank rows

I inserted an excel workbook file as an object into a MS Word document.  But when the excel object appears.   It's largerer than the sheet of paper I inserted it on.  And many of the lines are blank (see graphic)

I would like to get rid of the blank lines.

H--excel-error.png
brothertruffle880Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SimonConnect With a Mentor Commented:
Suggest that you first go into the Excel spreadsheet and use CTRL+END to find the last cell that Excel considers to be part of the 'used range'. If this is at the bottom of the extra blank rows, use CTRL+left arrow, the CTRL+up arrow to get to the last row of actual data, then move down one row, select the whole row and then do CTRL+down arrow to select all the rest of the rows and then delete the entire rows. Then select cell A1 and save the workbook, before trying to insert it again into the Word document.
0
 
brothertruffle880Author Commented:
Hi SimonAdept:
That helped.  However, I now have some spreadsheets that are appearing smaller in the Word Document and some that are spilling over into the right margins.
(See graphics below)
1             2
0
 
SimonConnect With a Mentor Commented:
Select each table and
1. Right-click it.
2. Choose Autofit and then select AutoFit to Window.

If it still doesn't fit you'd need to reduce the font size.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.