How to move the group plus/minus sign to top in Excel?
While tie range of cells together with the Group function in Excel, do you know how to move the plus or minus signs to the top of each group? Actually, you need to change the Outline settings. This article will show you step by step to achieve it.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
1. Go to the worksheet with group you want to move the plus/minus signs to top.
2. Click Data > Outline setting button. See screenshot:
3. In the Settings dialog box, uncheck the Summary rows below detail box, and then click the OK button. See screenshot:
Then you will see all group signs are moved to top of the group.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 5 months agoI HAVE ONE SET OF SUB GROUPS THAT IS NOT PUTTING A PLUS/MINUS SYMBOL!!!! HOW DO I FIX THIS AND WHY IS THIS HAPPENING?????
To post as a guest, your comment is unpublished.· 1 years agoThanks, it was a great help!
To post as a guest, your comment is unpublished.· 1 years agoFantastic, helped me