How to solve the problem that WPS cannot make partial modifications to merged cells

The solution to the problem that wps cannot make partial modifications to merged cells: 1. Cancel the merged cells first; 2. After selecting the cells that need to be merged, hold down "ctrl" "1" and click on the cell On the grid setting page, click to switch to "Alignment"; 3. Select "Center Across Columns" in "Horizontal Alignment"; 4. After clicking "OK", the content will be displayed centered across columns, and you can modify the content.

The operating environment of this tutorial: Windows 10 system, WPS 2021 version, DELL G3 computer.

Wps is not only compatible with multiple formats, but can also be used to create forms. It is an excellent office software. So what should friends do when they want to partially modify the merged cells in the Wps table? How to solve the problem that Wps cannot make partial modifications to merged cells? Let's take a look at the method of using Wps to make partial modifications to merged cells with the editor. Don't miss it if you are in need.

The solution to the problem that wps cannot make partial modifications to merged cells:

1. Many times when we modify the table, a message that we cannot make partial modifications to merged cells always pops up. Data modification.

#2. Next, we need to cancel the merged cells first.

3. After selecting the cells that need to be merged, press Ctrl 1, and on the cell settings page, click to switch to alignment.

#4. Select Center Across Columns for horizontal alignment.

#5. After clicking OK, the table title will be centered across columns.

#6. At this point, just adjust the table style.

If you need to modify the contents of merged cells in batches, you can do it in the following two ways: 1. Modify all merged cells in the current table Open the table that needs to be modified, select all the cells that need to be merged, right-click the mouse and select "Merge Cells". Then click "Cancel Merged Cells" and the merged cells will be cancelled. 2. Batch modify the merged cells in multiple tables. Open the table that needs to be modified, and select all the cells that need to be merged. Then hold down the Shift key and use the mouse to select all cells that need to be merged. You can also select merged cells in batches. Press Ctrl C to copy the selected content to the clipboard. Open the worksheet where the content needs to be pasted, and press Ctrl + V to paste the content into the cells to modify the contents of the merged cells in batches.

The above is the detailed content of How to solve the problem that WPS cannot make partial modifications to merged cells. For more information, please follow other related articles on the PHP Chinese website!