ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Microsoft Excel - Grouping and Sorting Cells (https://www.excelbanter.com/excel-worksheet-functions/27886-microsoft-excel-grouping-sorting-cells.html)

 Michael Blogg May 26th 05 12:16 PM

Microsoft Excel - Grouping and Sorting Cells

I have a particular group of cells within a sheet which I need to group
together and sort. However I need to keep the rows of information locked
together so when you sort the data it doesnt get all mixed up. Is there a
way to do this? If so, how?

If it is possible to do the above is it possible to have it to automatically

Is there a way that a "sort"
function can be set automatically for a group of particular cells?

For example;

I have set 6 columns on a spread sheet "Column B - Column G"

Say I have 150 rows of information starting at "Row 19 - 169"

However when I do sort all the data it jumbles all the information up. I
need to effectively lock the rows so the information doesn't get messed up.
So all the information in a row is tied to the first column and stays in
that order

 Jef Gorbach May 26th 05 09:27 PM

"Michael Blogg" wrote in message
...
I have a particular group of cells within a sheet which I need to group
together and sort. However I need to keep the rows of information locked
together so when you sort the data it doesnt get all mixed up. Is there a
way to do this? If so, how?

If it is possible to do the above is it possible to have it to

automatically

Is there a way that a "sort"
function can be set automatically for a group of particular cells?

For example;

I have set 6 columns on a spread sheet "Column B - Column G"

Say I have 150 rows of information starting at "Row 19 - 169"

However when I do sort all the data it jumbles all the information up. I
need to effectively lock the rows so the information doesn't get messed

up.
So all the information in a row is tied to the first column and stays in
that order

Sounds like like you're not selecting columns B:G prior to sorting to keep
the values across a given row together but sorted on whatever column you
need to; otherwise if you're trying to sort everything outside rows 19:169
while leaving those rows alone, you'll have to select and sort rows 1:18
then repeat for 170+.

 All times are GMT +1. The time now is 09:16 PM.