Solution: First open the Excel table that needs to be operated and cancel the part of the merged cells; then select the part of the cells that need to be merged and press the "ctrl 1" key on the keyboard; then in the new window that pops up Select the "Align" tab in the window, select the "Center Across Columns" option; finally click the "OK" button.
The operating environment of this tutorial: windows7 system, wps office2016 version, Dell G3 computer.
Many times when we modify the table, it always pops up that the data of the merged cells cannot be modified.
Then next, we need to cancel the merged cells first.
After selecting the part of cells that need to be merged, press Ctrl 1, and on the cell settings page, click to switch to alignment.
Select Center Across Columns at Horizontal Alignment.
#After clicking OK, the table title will be centered across columns.
At this point, just adjust the table style.
Related learning recommendations: excel tutorial
The above is the detailed content of What should I do if WPS cannot make partial modifications to merged cells?. For more information, please follow other related articles on the PHP Chinese website!