Group & outline: dots instead of plus & minus button

Sir Kraab

New Member
Joined
Nov 16, 2005
Messages
1
Howdy,
I have 14,000 records in 8 levels. No matter which order I group in (starting from level 1 or level 8), some of the groups show the plus/minus signs, but some show only a vertical column of dots that indicate which level the group's in.

Sometimes this happens within the same level -- i.e., I group one set of records on, say, level 3 and get the plus/minus, then immediately group another set and get the dots.

Clicking on the level numbers collapses and expands everything properly, but without the plus/minus I can't expand selectively.

Thanks for any suggestions.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,118,288
Messages
5,571,321
Members
412,382
Latest member
Langtn02
Top