Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 26th 05, 12:16 PM
Michael Blogg
 
Posts: n/a
Default 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.



  #2   Report Post  
Old May 26th 05, 09:27 PM
Jef Gorbach
 
Posts: n/a
Default


"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+.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel - Grouping and Sorting Cells Michael Blogg Excel Discussion (Misc queries) 1 May 26th 05 12:50 PM


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017