+ Reply to Thread
Results 1 to 2 of 2

Group Expanding Tables

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    Group Expanding Tables

    Hello everyone,

    Last week I learned how to set up a table so that it automatically expands row as I add more data. I also learned how to make groups of rows or columns.


    I want to know if there is a way to group table so that it will always detect the whole table and not just the number of rows I have at that particular moment. For example; I can group Column D from row 10-20. As soon as I add a new row (21 in this case) it will not be included in the group since at the time there were only 20. I want the group to recognize when I add a new row on my everexpanding table.

    any help?

    Thanks in advance.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Group Expanding Tables

    Post Deleted: Incorrect Response
    Cheers!
    Deep Dave

+ 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. Auto Expanding Tables
    By marlz in forum Excel General
    Replies: 0
    Last Post: 10-15-2014, 10:48 AM
  2. Hiding plus/minus sign for group expanding/collapsing on sheet
    By p.noia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2014, 03:43 PM
  3. Expanding Group using VBA
    By Sachburger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2013, 11:10 AM
  4. Adding to spread sheets but my tables are not expanding their range
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2013, 10:02 AM
  5. Expanding Cells In Pivot Tables
    By HappyCamperJon in forum Excel General
    Replies: 3
    Last Post: 04-28-2012, 02:16 AM
  6. Inserting range and expanding cells in tables
    By energizek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2010, 12:10 AM
  7. Expanding a Group and Printing
    By ebaymark2002 in forum Excel General
    Replies: 0
    Last Post: 03-09-2005, 05:49 PM

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