Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

group selection of rows in excel

Hi Experts,

    I need to group only selection of rows (few rows only, not all rows) in a pivot table in excel 2010  . Please walk me through the steps of how to achieve this ?

Please Note : I don't want grouping of all the rows. I know grouping of all rows is possible.

Thanks,

Srk.
0
n_srikanth4
Asked:
n_srikanth4
  • 2
1 Solution
 
nutschCommented:
Select the row headers (to select multiple non-contiguous row headers, hold Ctrl down while selecting with the mouse), right-click one of the headers and choose Group.

VoilĂ 

Thomas
0
 
n_srikanth4Author Commented:
Hi Thomas,

    I understand  abd know how to achieve the grouping.  But  I don't want to group all the rows. My requirement is to group only selection of few rows , not all of them. I am unable to achieve this , the rows which I don't want to group are going in to a default group which I don't want.

Regards,
Srk
0
 
nutschCommented:
If you only group part of the rows, the non-group rows will be created as a single group each. You can then remove the first row field to only show the groups rather than the original values, have you tried that?

Maybe a sample file showing how you see it, and how you'd want to see it would help.

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now