how do i sort a table in excel

[Guest]

as you can see below i have a table ive created for a website im working on
for a football team.. how would i script it to where when i started entering
in win's and loss's the team with the best record would automatically be
sorted at the top... the win's range is column " c "...

trey

Standing's
Atlantic Division ( Bold notate's a Home Game )
Eastern Division WON LOST % PF PA
Danbury Brigadier's 8 6 0.571428 571 594 552
Fayetteville Guard 7 7 0.5 620 527
Greensboro Revltn 8 6 0.571428 571 594 552
Tennessee Rivshrks 7 7 0.5 620 527
Mass. 8 6 0.571428 571 594 552
( Click here for full NIFL Team Standings )

 

[Fred Smith]

To do a sort, simply use the Data>Sort command. Make sure the active cell is in
the table you want to sort. It will help if you use a header row to identify the
columns. Then sort by column C (presumably in descending order as you want the
highest number of wins on top).

BTW plurals in English do not have an apostrophe, as in: Standings, wins,
losses, Brigadiers (and notates).

 

[Guest]

bear with me here... how i do the sort and have the accompany columns sort
with column c ? ? ?
column a is the team
column d are the losses
column e % of win's losses
column f points for
column g points against

the header is teams - wins - losses - % - points for - points against

 

[Fred Smith]

Highlight one of the cells in your table. Then choose Data>Sort...

Excel will automatically highlight all of the adjacent cells. This is the table
it will sort. Excel will move the whole row when it sorts on column c, so the
cells in the row will stay together.

If your table has blank cells in it, Excel may not choose exactly what you want.
In this case, highlight the whole table before you execute Data>Sort...

 

[Guest]

i get an error " this operation require's merged cells to be identicallyt
sized " and i have none... ????

 

[Guest]

i got it to work...thanks for the head's up...

Highlight one of the cells in your table. Then choose Data>Sort...

Excel will automatically highlight all of the adjacent cells. This is the table
it will sort. Excel will move the whole row when it sorts on column c, so the
cells in the row will stay together.

If your table has blank cells in it, Excel may not choose exactly what you want.
In this case, highlight the whole table before you execute Data>Sort...