Document Editing Problems

How to Split or Recreate a Word Table in Microsoft Excel

Ayan Masood Oct 7, 2026 869 views

Question details

The user is looking for a way to use Word's 'Split Table' feature in Excel in order to create a form with differently sized columns.

Product: Microsoft Excel, Microsoft Word
Device & OS: not provided
Scenario: Creating a complex form requiring columns of different sizes after transferring a layout from Word to Excel.
Observed behavior: The 'Split Table' command available in Word is not present in Excel, making it difficult to format the columns and table structures as originally intended.

Before you start

Ensure both your Word document containing the original table and a blank Excel workbook are open. Since Excel relies on a rigid grid system, be prepared to spend a few minutes manually adjusting cell dimensions and merging fields after transferring.

Solution 1Recommended

Transfer and Adjust the Word Table in Excel

The most straightforward method is to copy your existing table from Word and paste it into Excel, then manually adjust the formatting using column widths and cell merging.

Because Excel uses a fixed worksheet grid, it does not support Word's 'Split Table' feature. Instead, Excel allows you to format complex forms by merging and unmerging cells to create the illusion of differently sized columns.

Select and copy the Word table

Open your Microsoft Word document. Click the crosshair icon in the top-left corner of the table to select it entirely, then press Ctrl+C (or right-click and select Copy).

Paste into Microsoft Excel

Open your Microsoft Excel spreadsheet, click on the starting cell where you want the table to begin (e.g., A1), and press Ctrl+V to paste the table.

Adjust column widths manually

Hover your mouse between the column letter headers (e.g., between A and B) until the cursor turns into a double-sided arrow, then click and drag to adjust the column widths.

Merge cells for varied column sizes

To create wider text areas without affecting the rest of the column, highlight adjacent cells in a row, navigate to the Home tab, and click the 'Merge & Center' button.

Transfer and Adjust the Word Table in Excel

Formatting Loss: Be aware that complex borders, specific cell paddings, and nested tables from Word may not transfer perfectly into Excel and will require manual restyling.

Solution 2

Recreate the Form Layout Directly in Excel

For highly complex forms with heavily varied column sizes, it is often cleaner and more efficient to build the table from scratch natively in Excel.

Seamless Table Management

Create and Format Complex Forms with WPS Spreadsheet

WPS Spreadsheet provides powerful and intuitive formatting tools, including flexible cell merging and seamless compatibility with tables copied from WPS Writer or Microsoft Word, allowing you to design precise forms without hassle.

1. Copy your document table: Open your document in WPS Writer, click the table selection icon to highlight your form, and press Ctrl+C to copy it.
2. Paste into WPS Spreadsheet: Launch WPS Spreadsheet, open a new blank workbook, select cell A1, and press Ctrl+V.
3. Resize column boundaries: Click and drag the boundaries between the column letters at the top of the worksheet to precisely adjust your column widths.
4. Customize fields with Merge tools: Highlight multiple adjacent cells that require more space, then click 'Merge and Center' on the Home tab to combine them into custom form fields.

Seamlessly copy and paste tables from Word or WPS WriterIntuitive Merge and Center tools for complex form layoutsFully compatible with Microsoft Excel (.xlsx) formatsLightweight software with a familiar, easy-to-use interface

microsoft office alternative - wps office

Frequently Asked Questions

Does Excel have a Split Table feature exactly like Word?

No, Excel does not have a direct 'Split Table' command. Because Excel is built entirely on a rigid grid of cells, you manage table layouts by adjusting row heights, column widths, or by merging and unmerging multiple cells, rather than splitting an individual table entity.

How can I split a previously merged cell in Excel?

To revert a merged cell back into its individual cells, select the merged cell, go to the Home tab on the ribbon, click the drop-down arrow next to the 'Merge & Center' button, and choose 'Unmerge Cells'. Any data inside will be placed into the upper-left cell of the newly unmerged range.

Why does my Word table lose its formatting when pasted into Excel?

Word and Excel handle table structures fundamentally differently. Word allows independent column widths within the same table without affecting the document's margins. Excel enforces uniform column widths vertically across the entire worksheet. When pasting into Excel, the software attempts to map your table to its uniform grid, often disrupting complex formatting.

Document & File Issues