computer help please

[SGHOM]

how do I put in numerical order my leader board ?? can it be done easily ? or do I have to type it out each time ? [ excel] :thinking:

If I highlight the numerical columns It will put them in order, but not the names etc ?? ...... help :inquisiti

name; points this week; total.

adrian 4 7
BB 2 5
james & doug 3 6
rich lacy 3 6
lee allen 2 4
ken hex 0 3
chelsea james 3 5
baz 1 3
dodgy pete 3 5
rhianne & dave 0 2
bundy 2 3
glen plumber 2 3
gomes blades 0 1
keith smith 0 1
andy 1 1
paul richards 1 2
chelsea pete 0 1
woody 2 3
leigh platton 2 3
landlord 1 2
dave 0 1

edit; that didn't come out as I expected ??

[White Lightning]

Highlight all of the data that you want to alphabeticalise (if that's a word!) i.e. all rows and columns. Then select Data > Sort from the menu.

[ANTHONY]

kick it/pan

[stuartturbo]

highlight all then
data
sort
brings up box with sort by "column a" change to suit
and with and without header

[SGHOM]

Thankyou kind people :iloveyou:

I highlighted all then changed column F to descending order..... & that did it TY xx

[White Lightning]

Glad it's sorted :thumbsup:

[bradc]

when I was fiddling with that sort of thing in Excel I did the exact same thing, figured it out over the space of about 5 minutes after breaking it a few times :)

[d i c k i e s]

use database... easier!

[timiano]

use database... easier!

For a simple list in one table?

Pass me the crack pipe please....