+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 - grouping rows

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    5

    Excel 2010 - grouping rows

    I'm trying to group some rows in a sheet (to be able to collapse them), using the Data -> Group, Rows function. However, I'm able to group onr selection of rows, but when I try to group an adjacent selection it's just added to the first one. It works fine if the two groups are not adjacent, however.

    Anyone know how to group adjacent rows into diffent groups?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Excel 2010 - grouping rows

    No you can't... You should keep a column as a separator


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    03-25-2014
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 2010 - grouping rows

    Hm. Too bad. Oh, well - thanks for the answer. Guess I'll start inserting thin, empty rows then

+ 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. problem grouping dates in Pivot chart in Excel 2010
    By briano42 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-27-2014, 12:26 AM
  2. Excel 2010 VBA Help: Grouping Rows by text in A Column.
    By tiahuana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2013, 12:13 PM
  3. [SOLVED] How to hide Grouping/expansion section in excel 2010
    By v2k2apj in forum Excel General
    Replies: 2
    Last Post: 06-27-2013, 06:10 PM
  4. Replies: 0
    Last Post: 01-16-2013, 03:40 AM
  5. [SOLVED] Grouping of time slots in Excel 2010
    By Doctor Gooose in forum Excel General
    Replies: 4
    Last Post: 06-20-2012, 03:32 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