+ Reply to Thread
Results 1 to 2 of 2

grouping control box not showing up

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    Taylors, SC
    MS-Off Ver
    Excel 2007
    Posts
    3

    grouping control box not showing up

    I cannot seem to find an answer to a grouping issue. I have attached a file to show the issue I am having. Which is, whenever I group a secondary level (rows in this example) and the last item is the last item of the parent group, it appears (because the dots move to the third column) to create the group but the group control box (sorry if the is not the correct term but I am talking about the +- box for expanding and collapsing a group) does not appear.

    We would like to be able to collapse the sub-sub task as shown for the group 3 tasks in the "as saved" attached file. But as you can see there is no control box for the last set of sub-sub groups for tasks 1 & 2, yet the dots are in the correct column.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: grouping control box not showing up

    You need to un group everything.

    Insert a blank line between each task and sub task and regroup.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. calender 12.0 control showing incorrect date
    By UAZHAR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2013, 03:17 PM
  2. [SOLVED] Hiding/Showing a Form Control with another Form Control
    By SonOfOdin in forum Excel General
    Replies: 2
    Last Post: 06-20-2012, 09:55 AM
  3. Grouping and showing items only once..?
    By tangcla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-25-2008, 08:31 PM
  4. [SOLVED] Showing MsgBox after Control Toolbar macro runs
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2006, 09:05 PM
  5. How to turn off control toolbox while showing a userform
    By Noah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2006, 10:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1