98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Grouping rows in a spreadsheet
Grouping rows in a spreadsheet
Resolved · Urgent Priority · Version 2019
Tue 27 Oct 2020, 16:43Delegate Dunni said...
Dunni has attended:
Excel Intermediate course
Grouping rows in a spreadsheet
Hi, I need to group together rows that I have highlighted, which are in various parts of a spreadsheet, so that these are all visible together at the top of the spreadsheet I am working on. Please how would I go about doing this?
Wed 28 Oct 2020, 15:27Trainer Ron said...
RE: Grouping rows in a spreadsheet
Dear Dunni,
Thank you for your post in STL's forum.
To group a selection of rows first of all make sure that the entire rows are selected by clicking and dragging the actual row numbers.
Once the rows are selected, you select the Data tab --> Outline group and click 'Group.
You should see lines appear in the margin before the row numbers. You can now collapse or expand the grouped rows.
I hope this helps you.
Kind regards
Ron Oldeboom
STL-training
Wed 28 Oct 2020, 17:44Delegate Dunni said...
RE: Grouping rows in a spreadsheet
Hi Ron,
Thank you for getting back to me.
However, your suggestion has not resolved my issue. I get an error message: "This can't be done on a multiple range selection. Select a single range and try again."
Is there anything else that I can try to get the end result I require?
Thanking you in advance! Dunni
Thu 29 Oct 2020, 15:37Trainer Ron said...
RE: Grouping rows in a spreadsheet
Hi Dunni,
Yuo have to do the grouping one group of rows at a time. So don't select all the rows you wish to group but group them one set at a time. Certain actions in Excel can not be performed on discontinuous cells or rows or columns
So select your first batch of rows (need to be adjacent to eachother) and click group. Select the next batch of rows and group etcetera.
Hope this helps
Kind regards
Ron Oldeboom
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Naming and Using ConstantsConstants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant. |
