0903 Grouping Trick: Changing Placement of Grouping Button

1 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$189.27
You save:  A$54.08
List Price:  ৳11,874.45
You save:  ৳3,392.94
List Price:  CA$174.19
You save:  CA$49.77
CHF 90.63
List Price:  CHF 126.88
You save:  CHF 36.25
List Price:  kr876.09
You save:  kr250.33
List Price:  €117.79
You save:  €33.65
List Price:  £100.24
You save:  £28.64
List Price:  HK$1,087.91
You save:  HK$310.85
List Price:  ₹10,396.08
You save:  ₹2,970.52
List Price:  RM592.78
You save:  RM169.38
List Price:  ₦57,615.03
You save:  ₦16,462.61
List Price:  kr1,223.76
You save:  kr349.67
List Price:  NZ$199.75
You save:  NZ$57.07
List Price:  ₱7,023.18
You save:  ₱2,006.76
List Price:  ₨22,717.01
You save:  ₨6,491.03
List Price:  S$189.41
You save:  S$54.12
List Price:  ฿4,598.67
You save:  ฿1,314
List Price:  ₺1,183.81
You save:  ₺338.25
List Price:  B$707.83
You save:  B$202.25
List Price:  R2,037.17
You save:  R582.09
List Price:  Лв230.32
You save:  Лв65.81
List Price:  ₩160,005.91
You save:  ₩45,719.24
List Price:  ₪453.71
You save:  ₪129.64
Already have an account? Log In


Hi, this session is meant for people who already are using grouping and ungrouping in Excel. Now most of us who are aware of this particular feature would have used this quite often to group that have columns. What they would have seen is the button appears on the right hand side and not the left hand side. But when I did so this time you notice the button appear in the left hand side. Let's see how did I do it? When you're selecting a particular column or row, and you go to the group option under data tab, you notice this small icon, which points to this outline feature.

If I click on that, it gives you a variety of options, one of which says summary columns to the right of detail, which means if this checkbox is ticked on the button will be on the right hand side of the summarized set of columns. Let me see how it works. At this moment, I press OK. And notice how the button placement shifts From left to right. Similarly, if you're choosing a certain set of rules, and you group them, you'll notice the minus buttons appear at the bottom. How do we go on inside outline settings and take away this first option. Let's see what we get.

Notice this time the minus button appears at the top side and not at the bottom of the data selected. So this way, you can modify the placement of the grouping and ungrouping button. At this moment, what I'm gonna do is I'm going to change these settings back to default, which means I go to this outline option and check on these two boxes and keep it so. Okay, so this was an excellent trick for you.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.