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?
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
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
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
