Forum Discussion
How do I group multiple lines such that on Sort of the worksheet, the multiple lines stay together?
I'm glad I could help with your project.
I wish you continued success with Excel!
If this information helped you, please mark this post as "Correct answer" and/or click on Like button (hand with thumbs up), so that other members can see and benefit from this information later.
"2. Right-click on one of the selected rows and choose "Group" or "Group Rows" from the context menu.
3. This will group the selected rows together, and a small arrow will appear next to the first row to indicate that it is grouped."
Would you mind indicating in which Excel version this works as described? I found feature number 2 in Google Sheets but it comes back with plus and minus signs to indicate grouping. Not an arrow as suggested in point 3.
- You are correct, in Excel, when you group rows, a small plus sign (+) or minus sign (-) is displayed to indicate the grouping, not an arrow. The plus sign indicates that the grouped rows are collapsed, and the minus sign indicates that they are expanded. Since it helped the user, I think he discovered this himself. Thanks for the hint.
NikolinoDE It's point 2 in the AI answer that I'm most concerned about as it doesn't seem to apply to Excel at all. Unless I'm mistaken. Better to remove the incorrect AI generated instructions from the post all together, and rephrase/limit your post to that what helped the OP. That is, the part referring to the Outline group on the Data ribbon.
We wouldn't want AI bots picking-up on incorrect posts like this one and spread nonsense in the future.
