Choose the Excel Range Displayed in an Embedded Word Worksheet
Question details
Choose which cells are visible in an Excel worksheet embedded in a Word document.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user frequently edits an embedded worksheet and wants to show a presentation range while keeping calculation cells outside the visible area.
- Observed behavior
- The embedded worksheet may open in a separate Excel window, making the in-document boundary controls less accessible.
Open the Word document and identify the embedded worksheet and the cells you want to display. Check whether activating the object opens an in-document editing view or a separate Excel window.
Adjust the Embedded Worksheet Boundary in Word
Use in-place editing to change the displayed area when Word offers worksheet boundary handles.
Double-click the embedded worksheet in Word, or right-click it and choose Worksheet Object > Edit if that option is available.
If the worksheet opens inside Word, drag the boundary handles around the active worksheet to include the rows and columns you want to show.
Click outside the worksheet in the Word document and confirm that the intended cells are visible. If dragging only resizes the entire object or the worksheet opens in Excel, use another solution.

Hide Unwanted Rows and Columns in the Embedded Worksheet
Use this approach when the worksheet opens in a separate Excel window and the boundary cannot be adjusted in Word.
Re-embed a Prepared Excel Range in Word
Create a new embedded object from a selected range when the existing object's display is difficult to control.
Work With Word Documents and Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing files into WPS, though it does not fix Microsoft Word's embedded-object behavior.

Frequently Asked Questions
Why does the embedded worksheet open in a separate Excel window?
Office behavior can vary by version and object configuration. Double-click the object or try right-clicking it and choosing Worksheet Object > Edit; in-place editing may not be available.
Will dragging the object's outer handles change which cells are visible?
Not necessarily. Handles on an inactive object may only resize or scale it. If in-place editing is available, try the boundary handles around the active worksheet and check the result after clicking outside it.
Do hidden calculation cells still work?
Yes. Hiding rows or columns does not delete their values or formulas. In Excel, select the surrounding row numbers or column letters, right-click, and choose Unhide to show them again.
How can I embed only a selected Excel range in Word?
Copy the range in Excel, then in Word choose Home > Paste > Paste Special > Paste > Microsoft Excel Worksheet Object. Open the new object and verify its formulas and display.




