Get instant live expert help on I need help with excel group rows

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a list in excel. I want to split the rows in even groups, eg groups of 20 rows each, with the header on each group. I want each group in a separate file.
Solved by O. B. in 11 mins
I need to copy cells into a worksheet that is sorted with a filter where it keeps rows 1-10 for example of my copied cells and applies it to rows 1,7,35, etc in the sorted group. How Can I do this without, when coping the first group of cells, it only allowing me to copy rows 1,7,35 etc over to the sorted group?
Solved by A. A. in 16 mins
Color code rows by group name. Need better graphic design for end user usability complaint.
Solved by E. H. in 28 mins
I am trying to group multiple rows together so that when I sort them they stay together. For example Row 2 has the name and information to that name is still in rows 3, 4, 5, and 6. How do i group the rows together so that when I sort them those rows stay locked together?
Solved by A. J. in 15 mins
Hi, I have a table that shows a list of groups (group a, group b etc) and displays that there are 2 people in group 'a', 5 people in group 'b', 2 people in group 'c', 6 people in group 'd' etc... I would like to format/display the list show so it only shows the groups that have 2 or less people in each group... I am a complete excel novice.... Thanks you!
Solved by T. Q. in 26 mins