Sorting column B

**Virtual87** · 06-27-2011, 04:13 PM

Hello, I am pretty good with excel but a bit rusty since I didn't really need to use it in the past 2 years so I have created a tracking sheet for some players and I input how many points they have each day and then I have the B column where the Total adds up.
I want to automatically sort the players based on the values on column B but it needs to sort the whole row because there is the name on column A and then the points on each day or the rest of the columns on the same row.
I don't mind doing this in an external sheet if its easier but I just can't remember how to do this.
Thank you very much.

**NBVC** · 06-27-2011, 04:15 PM

If you select any cell within the table and go to Data|Sort you should be able to pick the column B header to sort by... then all the row items should follow along.

You can also select all the columns and do this to be more sure to get all data.

**Xx7** · 06-27-2011, 04:21 PM

Select all the data you want sorted. press Alt+DFF. Select the arrow at the top of column B for your criteria.

**Virtual87** · 06-27-2011, 05:11 PM

The easiest way was how Xx7 said and it done the job, its not automatic but im not lazy either so its perfect for me, thank you very much.
For future reference what is DFF stand for, D is for Data menu, what about F,F ?