Hide Details and Show Details (+) and (-)

CesarAustin

Board Regular
Joined
Aug 21, 2004
Messages
147
Hope someone can help me… I know this is simple but I just can’t figure it out… I’m trying to Hide details the kind that you have a small (-) and/or (+) at the top of the excel sheet… but my (-) and (+) buttons in my tool bar are shaded gray.. They just don’t work.. I have already make sure that the “outline symbols” check box is checked in my option table.. but for some reason they are still grayed out and I just can’t use them.. any help would be appreciated.
Thanks CesarAustin
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,722
Can I ask a couple of questions?

You are ... "trying to hide details but the "+" and "-" buttons on the toolbar are greyed out?" .... which toolbar exactly?

Does the sheet already have "outlined" sections or not?
 

CesarAustin

Board Regular
Joined
Aug 21, 2004
Messages
147
Ok.. I feel stupid :oops: .. it’s been a long time since I used that function… I figured it out… that (-) and (+) was to open and close the already established grouping.. I guess I need to group something 1st before the (-) and (+) worked… sorry..
 

Forum statistics

Threads
1,171,972
Messages
5,878,548
Members
433,351
Latest member
Cindy Little

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top