Grouping rows in a spreadsheet

Resolved · Urgent Priority · Version 2019

Tue 27 Oct 2020, 16:43 Delegate 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:27 Trainer 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:44 Delegate 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:37 Trainer 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

Thu 29 Oct 2020, 16:07 Delegate Dunni said...

RE: Grouping rows in a spreadsheet

Hi Ron,
Thank you for your response below.
I have 'cheated' and just chose to 'hide' the rows between the ones I want to group together... :~))
Many thanks,
Dunni

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Naming and Using Constants

Constants 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.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips