Formatting Issues

Create an Excel Table for Word Without Merged Cells in WPS Office

Nimra MalikNimra Malik Nov 13, 2026 868 views

Question details

The user wants to create a clean Excel table that can be pasted into Word without using merged cells, because merged cells often cause layout and editing problems.

Create an Excel Table for Word Without Merged Cells
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
Preparing a table in a spreadsheet that will be copied into Word while keeping a stable, editable layout.
Observed behavior
Merged cells cause issues when the table is edited, copied, or pasted into Word; the goal is to create the same visual structure with borders, alignment, shading, wrapping and adjusted column widths.
Before you start

Open the workbook in WPS Spreadsheets and make sure the table data is in a single continuous range with clear headers and no blank rows or columns inside the table. If any cells are already merged, unmerge them before applying borders and alignment.

Solution 1Recommended

Format an Excel table without merged cells using borders, alignment, shading and adjusted column widths

Use this method when you want a clean, editable table that copies from WPS Spreadsheets into Word without merged-cell layout issues.

Merged cells can break sorting, copying and pasting because they create an irregular grid. Borders, alignment, shading and text wrapping visually group data without changing the underlying cell structure.

1
Clear existing merged cells

In WPS Spreadsheets, select the table range, open the Home tab, click Merge & Center, and choose Unmerge Cells to remove all merged areas.

2
Apply borders around the table

With the range selected, click the Borders drop-down on the Home tab and choose All Borders. Use More Borders if you want a thicker outside border.

3
Format headers and row shading

Select the header row and use Bold and Fill Color on the Home tab. Select alternating body rows and apply a light shading, or use Format as Table for banded rows.

4
Set alignment and text wrap

Select all cells, open Home > Alignment, choose Center, and enable Wrap Text so long entries stay within the adjusted column widths.

5
Adjust column widths to fit content

Double-click the boundary between column headers or use Home > Format > AutoFit Column Width, then drag column boundaries to fine-tune the layout.

Safe, editable table structure: Keep the standard cell grid intact so the table pastes into Word cleanly and remains easy to edit later.
WPS Spreadsheets solution

Create and copy an unmerged Excel table with WPS Office Spreadsheets

Use WPS Office Spreadsheets to build a clean table with borders, alignment, shading, wrapping and adjusted column widths, then paste it into Word without merged-cell issues.

  1. 1. Open WPS Spreadsheets and prepare your data: Launch WPS Office, open or create a workbook, and arrange the data in a continuous range with one header row and no blank rows or columns inside the table.
  2. 2. Apply borders, shading and alignment from the Home tab: Select the range, then use the Borders, Fill Color, Bold, Alignment and Wrap Text commands on the Home tab to create a clear table structure.
  3. 3. Adjust column widths and row heights: Double-click column boundaries or use Home > Format > AutoFit Column Width to fit the content, and drag row dividers for consistent spacing.
  4. 4. Copy and paste into WPS Writer or Word: Select the finished range, press Ctrl+C, switch to WPS Writer or Microsoft Word, right-click and choose Keep Source Formatting to place the table.
Create clean, unmerged Excel tables that paste into Word without layout breakagePreserve .xlsx and .docx formatting across WPS Office and Microsoft OfficeUse borders, shading, alignment and conditional formatting instead of merged cellsFree download with a familiar Excel and Word interfaceLightweight and easy to use for everyday documents
microsoft office alternative - wps office

Frequently Asked Questions

Why do merged cells cause problems when copying an Excel table into Word?

Merged cells create an irregular grid, so Word may not preserve column positions and row heights. Borders, alignment, shading and wrapped text create the same visual effect while keeping a standard cell structure.

How do I create a table in WPS Spreadsheets without merging cells?

Select the table range, then use Home > Borders, Fill Color, Bold, Alignment and Wrap Text. Adjust column widths by double-clicking column boundaries or using Home > Format > AutoFit Column Width.

How do I copy an Excel table into Word without losing formatting?

Select the formatted range in WPS Spreadsheets, press Ctrl+C, open WPS Writer or Microsoft Word, right-click and choose Keep Source Formatting under Paste Options.

Can I use conditional formatting instead of merged cells?

Yes. Select the data, go to Home > Conditional Formatting, and create a rule to highlight cells based on their values. This highlights important information without changing the table grid.