Create and Cancel Group in WPS on Windows FAQ

Common questions about Create and Cancel Group in WPS on Windows usually involve collapsing detail data, grouping ranges, and synchronized worksheet editing; this FAQ includes 4 common questions and a glossary.

FAQ

How do I quickly collapse or expand detail data after creating a group?

1. After the group is created, look for the outline buttons on the left side or at the top of the worksheet.
2. Click level buttons such as 1, 2, or 3 to switch between detail levels.
3. Click the plus or minus button to expand or collapse the corresponding group.

Why can't I create a group successfully?

1. Check whether you selected contiguous rows or contiguous columns.
2. Make sure the selection does not span scattered areas that should not be grouped together.
3. Select the target range again and repeat the group action.

Why do edits affect multiple worksheets after I group worksheets?

1. This is the normal behavior of grouped worksheets.
2. While worksheets are grouped, edits made on one worksheet are applied to the other grouped worksheets.
3. If you want to edit only the current worksheet, ungroup the worksheets first.

Will my original data be lost after I ungroup rows or columns?

1. No. Ungrouping only removes the grouping structure.
2. The original cell content and values remain in place.
3. If needed, you can create a group again for the same range later.

Glossary