When you open an embedded Excel object, it will have a border with handles for resizing. See attached pic, with three of the six handles marked. Dragging those handles in/out will contract/expand the visible sheet by one row/column at a time.

Obviously, if someone has Word zoomed in too much to show the handles, they might have to scroll around or reduce the zoom to find them. Beyond that, you'll need to be more descriptive than merely saying it's "an absolute nightmare".

Attached Images

Untitled.png (11.0 KB, 14 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]