Formatting Issues

How to Center a Linked Excel Table in Word Without Breaking the Link

Aamir Naveed Akram Oct 8, 2026 869 views

Question details

The user needs to center a pasted linked Excel table in a Word document without disconnecting the live data link between the two files.

How to Center a Linked Excel Table in Word Without Breaking the Link

Product: Microsoft Word
Device & OS: not provided
Scenario: Pasting an Excel worksheet into Word as a linked object and adjusting its layout to center alignment.
Observed behavior: The linked table pastes off-center by default. Attempting to use text wrapping or manually repositioning the object breaks the active connection to the original Excel file.

Before you start

Ensure that both your source Excel workbook and the destination Word document are saved to your local drive or the same folder before creating the link to establish a stable file path.

Solution 1Recommended

Use Paragraph Alignment for Inline Objects

Keep the linked object in line with your text and center the entire paragraph to safely align the table without breaking the data connection.

When you change the text wrapping of a linked OLE object to a floating format (like Square or Tight), it can sometimes disrupt the dynamic link. Leaving the object as 'In Line with Text' and aligning the paragraph is the safest approach to adjust positioning.

Copy the Excel data

Open your Excel workbook, select the table or range of cells you want to link, and press Ctrl+C to copy it.

Paste Special into Word

Open your Word document, click the arrow under 'Paste' on the Home tab, and select 'Paste Special'. Choose 'Paste Link' and select 'Microsoft Excel Worksheet Object'.

Position your cursor

Once the table is inserted, click just outside the right edge of the table (between the table and the paragraph mark) to place your cursor on the same line.

Center the paragraph

Press Ctrl+E on your keyboard or click the 'Center' alignment button in the Paragraph group on the Home tab. The linked table will now be centered securely.

Use Paragraph Alignment for Inline Objects

Link Preserved: Because the table remains an inline text element, its connection to Excel is fully preserved. You can right-click and update the link anytime.

WPS Office Document Linking

Center Linked Spreadsheets Seamlessly in WPS Writer

WPS Office makes it easy to link your spreadsheet data into documents while maintaining perfect alignment and live data updates across files without frustrating formatting errors.

1. Copy Spreadsheet Data: Open your file in WPS Spreadsheet, select your target data range, and copy it to your clipboard.
2. Use Paste Special: Switch to WPS Writer, navigate to the Home tab, click the Paste dropdown arrow, and select Paste Special.
3. Link the Object: Choose 'Paste Link', select the WPS Spreadsheet Object format, and click OK to insert the data into your document.
4. Center Align: Click immediately to the right of the inserted object and click the Center Alignment icon on the Home tab to align the table perfectly.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Live OLE linking preserves real-time data updates reliably.Intuitive paragraph alignment settings for embedded spreadsheet objects.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel link break when I change text wrapping?

Changing text wrapping from 'In Line with Text' to floating options (like Square or Tight) alters how the Word layout engine handles the OLE object, which can sometimes sever the dynamic file path link to the original Excel file.

Can I update the linked table after centering it this way?

Yes. Because aligning the paragraph preserves the structural link, you can simply right-click the centered table in Word and select 'Update Link' to fetch the latest data from your Excel file.

What should I do if the 'Paste Link' option is missing or grayed out?

The 'Paste Link' option requires a definitive source file path. Ensure your Excel workbook has been properly saved to your drive before copying the data, and make sure you copy a defined range of cells rather than an entire worksheet tab.

Document & File Issues