ExcelBanter - How do I lock rows together?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I lock rows together? (https://www.excelbanter.com/new-users-excel/39179-how-do-i-lock-rows-together.html)

Brian Lynn

How do I lock rows together?

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

Gord Dibben

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?

All times are GMT +1. The time now is 05:53 AM.