A couple important things to note. Excel will
alert you if you have information to the right of
the column you are sorting and ask you if you
want that info to follow the sort. If however,
you have a column with nothing in it, inbetween
the column you are sorting and other information,
it won't ask you and will only sort the column
you are on. That can really mess you up as it'll
give you scores to the wrong people :). To avoid
this you can either not have a blank column
between them, or you can enter zeros in that
column and then set Excel to hide zeros.
Sometimes this is helpful if you want a visual
gap or borders, between information .
Additionally, I always highlight just the
information I want sorted, not the whole column
as it will otherwise sort the column heading as
well, which we don't really want.
You might find the sort feature also in the apps key or content menu.
Brad
On 12/20/2011 09:57 PM Cliff Smales said...
Each month, I do a spreadsheet for two bowling
leagues with which I also bowl.
Is there a command by which I can have my excel
program, excel 2003, list the bowlers by placement, first to last?
My office suite is Microsoft 2003.
I'm using windows, XP, Professional.
Many thanks for your help,
Cliff Smales
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
Brad Dunsé
"To rise with the sun is human, but to dance with
the moon is divine." --The Night Owl's Motto
http://www.braddunsemusic.com
http://www.facebook.com/braddunse
http://www.twitter.com/braddunse
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
