[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 81
  • Last Modified:

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
0
brothertruffle880
Asked:
brothertruffle880
  • 2
2 Solutions
 
SimonCommented:
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
 
SimonCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now