Excel for appmobiles.info 365 Excel 2021 Excel 2019 Excel năm 2016 Excel 2013 Excel 2010 Excel 2007 More...Less

Grouping data in a PivotTable can help you show a subset of data khổng lồ analyze. For example, you may want to lớn group an unwieldy list of dates or times (date and time fields in the PivotTable) inkhổng lồ quarters và months, lượt thích this image.

Bạn đang xem: Hướng Dẫn Sử Dụng Pivot Table

Note: The time grouping feature is new in Excel năm 2016. With time grouping, relationships across time-related fields are automatically detected & grouped together when you add rows of time fields to your PivotTables. Once grouped together, you can drag the group khổng lồ your Pivot Table và start your analysis.



Group data

In the PivotTable, right-click a value & select Group.

In the Grouping box, select Starting at and Ending at checkboxes, và edit the values if needed.

Under By, select a time period. For numerical fields, enter a number that specifies the interval for each group.

Select OK.

Group selected items

Hold Ctrl and select two or more values.

Xem thêm: Hướng Dẫn Cách Tải Email Về Máy Tính Nhanh Nhất, Cách Tải Toàn Bộ Email Về Máy Tính Nhanh Nhất

Right-cliông chồng và select Group.

Name a group

Select the group.

Select Analyze > Field Settings.

Change the Custom Name lớn something you want and select OK.

Ungroup grouped data

Right-cliông xã any nhà cửa that is in the group.

Select Ungroup.

Need more help?

You can always ask an expert in the Excel Tech Community or get tư vấn in the Answers community.

See Also

Create a PivotTable to lớn analyze worksheet data


Need more help?

Expvà your skills
Explore Training
Get new features first
Join appmobiles.info Insiders

A subscription khổng lồ make the most of your time
Try one month free

Was this information helpful?

Thank you! Any more feedback? (The more you tell us the more we can help.) Can you help us improve? (The more you tell us the more we can help.)

What affected your experience?

Resolved my issue
Clear instructions
Easy to lớn follow
No jargon
Pictures helped
Didn't match my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures

Any additional feedback? (Optional)

Submit feedback

Thank you for your feedback!

What's new
appmobiles.info Store
English (United States) © appmobiles.info 2021