WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Merge Cells in Table in WPS Office: A Step-by-Step Guide

September 25, 2023
6.3K Views

Merging cells within a table is a fundamental aspect of working with spreadsheets and documents in WPS Office. We will guide you in merging cells in the WPS Office. Our goal is to provide you with a step-by-step guide on how to merge cells in WPS Office. Let's explore the process of merging cells together and make your experience with WPS Office as smooth and productive as possible.

Part 1. How to Merge Tables in WPS Spreadsheet

After we use WPS Office to open the spreadsheet,  select the cell that needs to be manipulated.

Then click the Home tab and find the Merge and Center button. By clicking this button, we can quickly merge and center cells. Its shortcut key is Ctrl+M, here are the detailed steps with a video:

This skill could be also used in Microsoft Office Excel and Openoffice.

My Personal Comments: Merging tables in WPS Spreadsheet can be a rewarding yet intricate process. Through my own experiences, I've come to appreciate the importance of meticulous data preparation, the choice of the right merging method, and the need for continuous data validation to ensure accuracy. It's a skill that requires patience and adaptability, but the ability to effectively merge tables can significantly enhance data management and analysis capabilities.

Part 2: How to Merge Tables in WPS Writer?

Option 1:

Step 1: Select the cells to be merged.

Step 2: Go to theTable Tools Tab→click Merge Cells.

Here are the detailed steps with a video:

Option 2:

Step 1: Select the cells to be merged.

Step 2: Right-click on it →choose Merge Cells from the pop-up menu.

No matter if you are a student, teacher, or business professionals can create and edit documents efficiently by WPS Writer as text editors. Easy to use as Microsoft Word.

My Personal Comments: The most challenging aspect for me was definitely the copying and pasting step. Ensuring that the data aligns correctly and that headers match up requires careful attention. However, with practice, it becomes more manageable. Remember to save your work regularly to avoid any accidental data loss. With patience and attention to detail, you can effectively merge tables in WPS Writer to create organized and visually appealing documents.

Part 3: How to Split Cells in a Table in WPS Writer?

Step 1: If we want to divide a cell into several cells, we can select the cell that needs to be split.

Step 2: Click the Split Cells button in the Table Tools tab.

Step 3: In the pop-up dialog box, we can set the number of columns and rows we need to split the table into.

Step 4: Enter 3 in Number of columns and 2 in Number of rows.

Step 5: After setting, click the OK button.

Here are the detailed steps to split cells in a table in WPS Writer with a video:

Part 4. Why Choose WPS Office ?

WPS Office is a versatile and user-friendly free office suite that allows users to open, create, edit, and save Microsoft Office files, including Word documents, Excel spreadsheets, and PowerPoint presentations. It offers full compatibility with Windows and Mac operating systems, making it a convenient choice for individuals and businesses looking for an affordable alternative to the Microsoft Office suite. With a familiar interface and a wide range of features, WPS Office provides a seamless experience for working with various document formats, enhancing productivity across different platforms.

Here's a brief introduction to its key features:

  • Compatibility:

WPS Office is fully compatible with Microsoft Office formats, including Word (.docx), Excel (.xlsx), and PowerPoint (.pptx). This means you can open, edit, and save files in these formats without compatibility issues.

  • Writer (Word Processor):

Rich text editing with a familiar Word-like interface.

Advanced formatting options, including styles, templates, and page layout.

Collaboration tools for real-time document editing and commenting.

  • Spreadsheets (Excel):

Powerful spreadsheet capabilities with formula support.

Data analysis tools, charts, and pivot tables.

Data encryption and protection features.

  • Presentation (PowerPoint):

Create visually appealing slideshows with various templates and effects.

Multimedia support for adding audio, video, and images.

Slide transition and animation effects.

  • Free Version:

WPS Office offers a free version with most of its essential features, making it accessible to a wide range of users. There's also a premium version with additional features and support.

Trustpilot

stars

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

avator

Algirdas Jasaitis
logo

FAQs

1. How do you merge two tables in WPS Office?

Step 1: Open WPS Spreadsheet on your computer.

Step 2: Browse the excel sheet which contains your data.

Step 3: On the ribbon menu, go to the Tools tab and click on the “Split or Merge”

Step 4: A Document Split and Merge will window will pop-up, click on “Merge”

Step 5: Users can now simply click on “ Add more files” to add the documents they want to merge.

Step 6: Once the documents have been added to the process, users can then click on “Next”.

Step 7: Now, a preview will be displayed. This window will show what documents are being merged and their data. Users can also set the document name for their merged Excel file on this window. Click on “Merge” to start the process.

Step 8: WPS Spreadsheet will notify once the merging is complete. Users can view their merged files.

2. What is the shortcut key to merge two tables?

Method 1: Click on the table you want to drag, then the cross sign will appear, then click the cross sign to select the whole table.

Method 2:

  • Press Shift + Alt + Up arrow until the selected table is joined to above one.

  • Press Shift + Alt + Down arrow to combine with below table.

3. How do I merge PDF files in WPS online?

All you need to do is go on WPS Office’s merge PDF and upload the documents that you want to be merged. Select them, and then click “Merge”. Once the process is complete, the merged document will appear in your browser window for viewing and downloading. You can then save it to your computer or print it out for later use

Summary

Merging cells in a table within WPS Office is a valuable formatting tool that empowers users to design well-structured and aesthetically pleasing documents. By merging cells, you can unify specific cells into one, effectively expanding their coverage across multiple rows or columns. This capability is especially beneficial for tasks such as creating headers, enhancing data presentation, and optimizing the overall visual organization of tables.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.