| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move exact information in a row as you sort a column
In a excel worksheet, Is it possible to move information in rows
automatically as accend sorting is being done? If so, how do I do it.? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move exact information in a row as you sort a column
Yes, just select the entire table before performing the sort. Or, make sure just
one cell is highlighted, then run the sort. Excel will include all adjacent cells in the sort. -- Regards, Fred "Michaela" wrote in message ... In a excel worksheet, Is it possible to move information in rows automatically as accend sorting is being done? If so, how do I do it.? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move exact information in a row as you sort a column
GREAT ANSWER.!! It did the job..!! Thank You
"Fred Smith" wrote: Yes, just select the entire table before performing the sort. Or, make sure just one cell is highlighted, then run the sort. Excel will include all adjacent cells in the sort. -- Regards, Fred "Michaela" wrote in message ... In a excel worksheet, Is it possible to move information in rows automatically as accend sorting is being done? If so, how do I do it.? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| Sort column and take row info with it. | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| Sort as "reference column" | Excel Discussion (Misc queries) | |||
Linear Mode
