ExcelBanter

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
sort the information as your adding it into cells?

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

Thank you for your time.



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
sort the information as your adding it into cells?

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

Thank you for your time.



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.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
ExcelBanter.com