What should I do if the sizes of merged and sorted cells in WPS must be the same?

#wps What should I do if the size of the cells to be sorted and merged must be the same?

1. First, open the table we want to operate on in Excel, and then select the entire table.

2. Find and click "Clear" in the upper menu bar, as indicated by the arrow in the figure below:

3. After clicking "Clear Format" in the pop-up options, you can sort normally.

#4. Find and click the title we want to sort, and then click "Sort and Filter" in the menu bar above.

#5. In the pop-up options, select the sorting method according to your own needs. The editor here selected "descending order".

6. The final effect is as shown below:

The above is the detailed content of What should I do if the sizes of merged and sorted cells in WPS must be the same?. For more information, please follow other related articles on the PHP Chinese website!