How to eliminate grayed out rows at bottom of table?

[Mark Huebner]

I have an Excel spreadsheet in a Word 2002 document. There are 4 rows at
the bottom that are empty and grayed out. I would like to eliminate them
because they are taking up space in my document. How can I remove these
empty rows from my Excel table?

 

[Candice Mesk]

While in Word, double-click to edit the spreadsheet. Resize the object so
that only the rows and columns you want are visible. Now double-click
outside of the spreadsheet to restore the focus back to Word. The Excel
object should be just the right size.

You must ensure that your Excel spreadsheet object has focus when you
resize. If you try and resize the object while Word has focus, the object
behaves like a picture.