How do I lock rows together?

B

Brian Lynn

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?
 
K

Kassie

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
 
G

Gord Dibben

Brian

Don't let Excel guess where your datarange starts and stops.

Select all columns prior to sorting.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I print rows that go outside of the page without shrinking the text? 0
Insert Index into a Table 1
adding rows into the table 1
How do I match values in a sub set after a sort? 1
Unclear change tracking process 0
Keeping Rows Together 1
keeping the rows together 10
Help needed for inserting a row. 0

Top