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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
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,136,369
Messages
5,675,360
Members
419,565
Latest member
Phil57

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