+ Reply to Thread
Results 1 to 5 of 5

Automatically expand group size rows when new data is added ?

  1. #1
    Registered User
    Join Date
    02-19-2015
    Location
    usa
    MS-Off Ver
    excel 2010
    Posts
    18

    Automatically expand group size rows when new data is added ?

    Hi,


    Can i have groups automatically expanded when new items are added?

    I have a grouped rows 1 to 5
    I am at row 5
    I press enter so I am at a row 6 ,but my selection group didn't expend to 1-6

    Could I have it expended automatically when adding new items into the group?


    Thank you

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Automatically expand group size rows when new data is added ?

    deleted, misunderstood problem
    Last edited by protonLeah; 11-19-2016 at 08:57 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-19-2015
    Location
    usa
    MS-Off Ver
    excel 2010
    Posts
    18

    Re: Automatically expand group size rows when new data is added ?

    I'm not sure if I have used correct terminology

    by GROUP is mean the option to select rows by going to DATA then GROUP +
    Would it still be true that I could use dynamic name range and then my GROUP would expend automatically?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Automatically expand group size rows when new data is added ?

    deleted, misunderstood problem
    Last edited by protonLeah; 11-19-2016 at 08:57 PM.

  5. #5
    Registered User
    Join Date
    02-19-2015
    Location
    usa
    MS-Off Ver
    excel 2010
    Posts
    18

    Re: Automatically expand group size rows when new data is added ?

    http://helpdeskgeek.com/office-tips/...more-readable/


    When I group the items and then I want to add a new item to the same group, it doesn't expend automatically.
    I think it is possible to do it.

+ 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. [SOLVED] Duplicate/Expand column formula when rows are added?
    By NewYears1978 in forum Excel General
    Replies: 2
    Last Post: 06-14-2016, 02:41 PM
  2. Automatically copy to new rows to new rows as raw data is added on another worksheet
    By lanoushi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-12-2013, 09:03 AM
  3. Keep page size the same when rows expand?
    By mickyh in forum Excel General
    Replies: 3
    Last Post: 07-28-2012, 04:30 AM
  4. Automatically expand named range when new data is added
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2011, 07:43 PM
  5. Automatically moving data rows to other sheets as new entires are added.
    By yehuoy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2011, 05:11 PM
  6. Replies: 3
    Last Post: 02-14-2008, 02:39 PM
  7. automatically expand chart data series as data is added
    By jlarson in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2006, 06:35 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