Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sort the data in 8 columns by two of the columns?
I have a worksheet with 8 total columns. Columns five thru eight are laid
out the same as one thru four. I need to sort the info in columns one and five in ascending order. Is there a way to do this or do I have to cut 5 - 8, paste under 1 - 4, sort, then cut and paste them back?? |
#2
|
|||
|
|||
How do I sort the data in 8 columns by two of the columns?
Select the exact range of cells (like E1:H100) and use the Sort command. You
will be presented with a dialog asking if you want to expand the selection. Choose no and do your sort. Then select A1:D100 & repeat. Bob Umlas Excel MVP "Sorting" wrote in message ... I have a worksheet with 8 total columns. Columns five thru eight are laid out the same as one thru four. I need to sort the info in columns one and five in ascending order. Is there a way to do this or do I have to cut 5 - 8, paste under 1 - 4, sort, then cut and paste them back?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting data from a spreadsheet by searching on columns | New Users to Excel | |||
Concatenate columns with cell data containing Carriage Returns | Excel Worksheet Functions | |||
Sort - max number of columns? | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |