Abe,

Select all the used columns in your worksheet, e.g., A:L, then go
to the Data menu, choose Sort, and select the column by which you
want the data sorted.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Abe" wrote in message
...
Hey all, I have a worksheet that has 12 columns and 50 rows. I
want to sort
by various columns, do I need to select the entire worksheet so
that the
information is sorted correctly?

Here is an example of my sort

first name - last name - age - phone # - address - zip code

I want to say "sort by last name" or "sort by age"

Thanks!