Right-click a value in the PivotTable and choose Group.
Select the Starting at and Ending at checkboxes in the Grouping box, then modify the values as necessary.
Select a time period under By. Enter a number that specifies the interval for each group in numerical fields.
Choose OK.
Ungroup... from the context menu by right-clicking the grouped field. Select any cell in the grouped field and click the Ungroup button in the Group group on the Pivot Table Tools | Analyze tab.
If your dataset just has one level of information, the quickest method is to have Excel automatically arrange rows for you. This is how: To group cells, select any cell in one of the rows. Select Auto Outline from the Data tab > Outline group, then click the arrow under Group.
In Excel, press Alt Shift right arrow in Windows or Command Shift K on a Mac to group rows or columns. This shortcut will open the Group dialogue box if you only have cells selected (not complete rows or columns). You can tell Excel to group Rows or Columns there.
To group rows or columns quickly, select the rows or columns you want to group and press ALT+SHIFT+RIGHT ARROW to group them, and ALT+SHIFT+LEFT ARROW to ungroup them. You can also play on numerous levels (so you could group rows 1-30, and then group rows 20-25 as a subgroup of the first).
Learner's Ratings
4.7
Overall Rating
82%
10%
5%
3%
0%
Reviews
I
Ibrahim Khalil
5
Very good
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
Share a personalized message with your friends.