Create an Excel Table for Word Without Merged Cells in WPS Office
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.

- 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.
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.
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.
In WPS Spreadsheets, select the table range, open the Home tab, click Merge & Center, and choose Unmerge Cells to remove all merged areas.
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.
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.
Select all cells, open Home > Alignment, choose Center, and enable Wrap Text so long entries stay within the adjusted column widths.
Double-click the boundary between column headers or use Home > Format > AutoFit Column Width, then drag column boundaries to fine-tune the layout.
Copy the formatted table from WPS Spreadsheets and paste it into Word
Use this after formatting the unmerged table to transfer it into Word while preserving borders and layout.
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. 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. 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. 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. 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.

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.




