can you group together rows to remain intact while sorting?
 

I have a list which needs to consilidated with another and then sorted
chronologically. I neede to lock or group together certain set of rows
please i am way past my deadline......thanks

Answer: can you group together rows to remain intact while sorting?
 

Yes, you can definitely group together rows in Excel to keep them intact while sorting. Here's how you can do it:

1. Select the rows that you want to group together by clicking and dragging your mouse over the row numbers on the left-hand side of the worksheet.
2. Right-click on one of the selected row numbers and choose "Group" from the drop-down menu. This will group the selected rows together.
3. You will see a small minus sign (-) appear next to the row numbers that are now grouped together. You can click on this minus sign to collapse the group and hide the rows, or click on the plus sign (+) to expand the group and show the rows.
4. Now, when you sort your data chronologically, the grouped rows will stay together and maintain their order within the group.
5. To ungroup the rows, simply select the grouped rows and right-click again, then choose "Ungroup" from the drop-down menu.

I hope this helps you consolidate and sort your data quickly and efficiently!

can you group together rows to remain intact while sorting?
 

Add a helper column
Put numbers in this column
Row that must stay together, give same number
Use this as the first sort key
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"justusmomm" wrote in message
...
I have a list which needs to consilidated with another and then sorted
chronologically. I neede to lock or group together certain set of rows
please i am way past my deadline......thanks

can you group together rows to remain intact while sorting?
 

When you use "Subtotals" or "Group & Outline", you can sort the summary
(subtotal) rows, leaving the grouped rows intact, as individual units.

For example, to manually group some rows, enter A, B, C, ...etc down Column
A, say to A20.

In B1 enter
1/1/07

In C1 enter
=Rand()

Select *both* B1 and C1, and using the fill handle, drag down to Row 20.
While both columns are *still* selected, click,
<Data <Sort
Sort by Column C - <OK

You now have Column A in order, with various dates in Column B.

Select rows 1, 2, and 3 by clicking in the row headers.
While these rows are selected,
hold down <Shift and <Alt
and hit the <Right Arrow.

You have now manually grouped the first 3 rows, with A, B, and C.

Do exactly the same thing, grouping rows 8, 9, and 10, with H, I, and J,
and also rows 16, 17, and 18, with P,Q, and R.

You see the minus sign by rows 4, 11, and 19.
This means that *each* 3 row group will remain intact, and sort as a group,
depending on the value in rows 4, 11 and 19.

NOW ... select A1 to B20, and sort on Column B.

This puts everything in chronological order, *except* the individual groups,
which are dependant on the date in their respective summary rows.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"justusmomm" wrote in message
...
I have a list which needs to consilidated with another and then sorted
chronologically. I neede to lock or group together certain set of rows
please i am way past my deadline......thanks

can you group together rows to remain intact while sorting?
 

FWIW,

After the sort, you can hit:
<Ctrl <8
to toggle the Outline symbols to display or hide.

That "8" *must* be the 8 that's under the function keys.
The one from the num keypad *doesn't* work!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
When you use "Subtotals" or "Group & Outline", you can sort the summary
(subtotal) rows, leaving the grouped rows intact, as individual units.

For example, to manually group some rows, enter A, B, C, ...etc down
Column
A, say to A20.

In B1 enter
1/1/07

In C1 enter
=Rand()

Select *both* B1 and C1, and using the fill handle, drag down to Row 20.
While both columns are *still* selected, click,
<Data <Sort
Sort by Column C - <OK

You now have Column A in order, with various dates in Column B.

Select rows 1, 2, and 3 by clicking in the row headers.
While these rows are selected,
hold down <Shift and <Alt
and hit the <Right Arrow.

You have now manually grouped the first 3 rows, with A, B, and C.

Do exactly the same thing, grouping rows 8, 9, and 10, with H, I, and J,
and also rows 16, 17, and 18, with P,Q, and R.

You see the minus sign by rows 4, 11, and 19.
This means that *each* 3 row group will remain intact, and sort as a
group,
depending on the value in rows 4, 11 and 19.

NOW ... select A1 to B20, and sort on Column B.

This puts everything in chronological order, *except* the individual
groups,
which are dependant on the date in their respective summary rows.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-


"justusmomm" wrote in message
...
I have a list which needs to consilidated with another and then sorted
chronologically. I neede to lock or group together certain set of
rows
please i am way past my deadline......thanks