| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I lock rows together?
I have data that would look like this:
Name | Date | Address | Performance | Average | Best in each column is the corresponding data... Is it possible to lock together each row? I want to be able to sort by any column and have the data stay with it across the rows... i.e: Brian | 2/2/05 | 22 B Lane | 5 | 4 | 13 Chris | 2/2/05 | 11 C Lane | 6| 5 | 10 So if I sort by the Best column Brian would stay on top... If I sort by the Average Column then Chris would be on top... Is this possible? Or is there a way to do this that I am just missing? |
|
#2
|
|||
|
|||
|
Hi Brian
Select the range you want to sort, click on Data|Sort. Select the column you want to sort by, and sort in Descending order, and you will get the desired result -- ve_2nd_at. Randburg, Gauteng, South Africa "Brian Lynn" wrote: I have data that would look like this: Name | Date | Address | Performance | Average | Best in each column is the corresponding data... Is it possible to lock together each row? I want to be able to sort by any column and have the data stay with it across the rows... i.e: Brian | 2/2/05 | 22 B Lane | 5 | 4 | 13 Chris | 2/2/05 | 11 C Lane | 6| 5 | 10 So if I sort by the Best column Brian would stay on top... If I sort by the Average Column then Chris would be on top... Is this possible? Or is there a way to do this that I am just missing? |
|
#3
|
|||
|
|||
|
Brian
Don't let Excel guess where your datarange starts and stops. Select all columns prior to sorting. Gord Dibben Excel MVP On Sun, 7 Aug 2005 11:45:25 -0700, "Brian Lynn" wrote: I have data that would look like this: Name | Date | Address | Performance | Average | Best in each column is the corresponding data... Is it possible to lock together each row? I want to be able to sort by any column and have the data stay with it across the rows... i.e: Brian | 2/2/05 | 22 B Lane | 5 | 4 | 13 Chris | 2/2/05 | 11 C Lane | 6| 5 | 10 So if I sort by the Best column Brian would stay on top... If I sort by the Average Column then Chris would be on top... Is this possible? Or is there a way to do this that I am just missing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lock worksheet and still able to click on grouped rows | Excel Worksheet Functions | |||
| Lock Rows | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Hybrid Mode
