| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I match all columns into descending order
I have columns A-Gthat include A - Parents name, C-players name, E- Phone
numbers, and G-email address. I want to sort in Alpha order, but all cells must match the original imput. How do I do this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I match all columns into descending order
have you looked in the help index for SORT
-- Don Guillett SalesAid Software "Kiwi Jane" <Kiwi wrote in message ... I have columns A-Gthat include A - Parents name, C-players name, E- Phone numbers, and G-email address. I want to sort in Alpha order, but all cells must match the original imput. How do I do this? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I match all columns into descending order
To keep data together as you sort............
Select all the columns prior to doing the sort on whichever column you wish to sort on. Then DataSortpick a column and follow your nose. Gord Dibben MS Excel MVP On Thu, 12 Oct 2006 14:50:01 -0700, Kiwi Jane <Kiwi wrote: I have columns A-Gthat include A - Parents name, C-players name, E- Phone numbers, and G-email address. I want to sort in Alpha order, but all cells must match the original imput. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Re-organise columns so they appear in alphabetical order? | Setting up and Configuration of Excel | |||
| match and sort columns | Excel Worksheet Functions | |||
| If columns match | Excel Worksheet Functions | |||
| HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL | Excel Worksheet Functions | |||
| changing column's order | Charts and Charting in Excel | |||
Linear Mode
