How to Merge Cells in a SharePoint Communication Site Table
Question details
The user needs a method to merge table cells within a SharePoint Communication Site because the default built-in tools do not support this formatting.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Designing and formatting tables within the Text web part on a SharePoint Communication Site page.
- Observed behavior
- The SharePoint Text web part does not include a native command or option for merging or combining cells in an inserted table.
Ensure you have access to a spreadsheet application like Excel for the web or WPS Spreadsheet, as you will need it to format your table before pasting it into SharePoint.
Use an External Spreadsheet to Merge Cells and Copy to SharePoint
Since SharePoint's Text web part lacks a native merge tool, you can create the desired table layout in a spreadsheet, merge the cells there, and paste it directly into SharePoint.
Because the SharePoint Text web part operates as a basic rich text editor, it does not support complex table formatting like merged cells natively. The most reliable workaround is designing the table externally and pasting it in.
Open Excel for the web, desktop Excel, or WPS Spreadsheet and create a new blank workbook.
Input your data into the spreadsheet. Highlight the cells you wish to combine, then click the 'Merge & Center' button located on the Home tab.
Select the entire table in your spreadsheet and press Ctrl+C (Windows) or Cmd+C (Mac) to copy it to your clipboard.
Navigate to your SharePoint Communication Site page. Edit the page, click inside the Text web part, and press Ctrl+V (Windows) or Cmd+V (Mac) to paste. The merged cell layout will be preserved.

Easily Format Complex Tables with WPS Office
If you frequently find web-based Office tools restrictive, WPS Office offers a powerful, lightweight, and completely free alternative. You can easily design complex tables with merged cells in WPS Spreadsheet and copy them anywhere seamlessly.
- 1. Download WPS Office: Install WPS Office Free on your device and launch WPS Spreadsheet.
- 2. Design Your Table: Use the built-in 'Merge and Center' tools to create the exact layout you need.
- 3. Paste to SharePoint: Copy the customized table from WPS Spreadsheet directly into your SharePoint site.

Frequently Asked Questions
Can I merge cells natively within the SharePoint Text web part?
No, the SharePoint Text web part is currently a basic editor and does not have a built-in feature to merge or split table cells natively.
Will the cell merging be lost if I edit the table inside SharePoint later?
Editing the text inside the pasted table is fine and will not break the formatting. However, altering the table structure (such as adding new columns or rows) in SharePoint might break the merged layout.
Can I use Microsoft Word instead of Excel to create the merged table?
Yes, you can also create a table with merged cells in a word processor like Microsoft Word or WPS Writer, and paste it into the SharePoint Text web part. Both methods generally preserve the merged cell structure.




