Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort parameters
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
Look at sort in help?
-- HTH Bob Phillips "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! |
#4
|
|||
|
|||
Not the whole worksheet, the whole range say A1:L50
Select the entire range then sort. Don't let XL pick it for you as it has a habit of occasionally scrambling it, Regards, Alan. "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! |
#5
|
|||
|
|||
If you have empty columns in the range you want to sort, you will have to
select that range (or the entire sheet) before sorting. If none of the columns within your range are empty, clicking any cell in the column you want to sort by, and then clicking one of the sort buttons will do it. If you want to check whether Excel has guessed your intended range correctly, after selecting a cell in the column you want to sort by, go to DataSort. Excel will highlight the range that it is about to sort. DataSort will also let you select up to three columns to sort by in one go. "Abe" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Sort Parameters | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |