How to group data in a spreadsheet

Uploaded time: 2021-08-31 Difficulty: Primary

How to group data in a spreadsheet

How to group data in a spreadsheet

Graphic skills

When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity.

 

The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category.

1. Select cells of Column B and Column K.

2. Get into the Data tab, and click the Group button.

(Tips: You can also press the shortcut keys Shift+Alt+Right instead. )

Then we would have finished grouping data.

GIF.gif

 

For a better demonstration, the data can be further grouped into different levels.  

1. Select the groups recording data respectively from January to April.

2. Click the Group option.

Similarly, we can further group the data during May and April at a higher level.

(Note that we need to keep the cell area between every two groups. Or else, the data within a continuous range would be placed into the same group. )

GIF_1.gif

 

As we can see, several numbered buttons are presented on the left-hand side of the rows.

Click the button, then WPS Spreadsheets will present different levels of data.

In this way, we can emphasize the significant points in the sheet and view relationships among data more clearly.

GIF_2.gif


1. Select the cells.

2. Click the Hide Detail or the Show detail button to hide or present the data in the sheet.

Tips: Another option to realize these is to click the plus (+) or minus (-) symbols.

GIF_3.gif

 

To ungroup the cells, please follow the next few steps.

1. Select the cell ranges to be ungrouped.

2. Click the Ungroup button, or press the shortcut Shift+Alt+Left to finish the operations.

GIF_4.gif

 

To be office excel advancers, you could watch more videos online in WPS Academy.