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
83%
10%
4%
3%
0%
Reviews
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.