Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort rows by the contents of one cell
I have a large worksheet that has multiple coulmns of data, in different
formats. The problem is I need to sort decending based on just one coulmn. however when I try to do that it just moves that single coulmn around. is there any way to "lock" the row together and then let me adjust by the data in that coulmn? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort rows by the contents of one cell
yes, select all the rows, click on heading A, hold shift key down and click
on the last column or just click on the blank square up in the corner between A and 1, that selects everything "bhaight58" wrote: I have a large worksheet that has multiple coulmns of data, in different formats. The problem is I need to sort decending based on just one coulmn. however when I try to do that it just moves that single coulmn around. is there any way to "lock" the row together and then let me adjust by the data in that coulmn? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
Inserting rows while keeping cell contents the same | Excel Discussion (Misc queries) | |||
Transferring cell contents from selected rows only. | Excel Worksheet Functions | |||
hiding rows based on cell contents | Excel Discussion (Misc queries) | |||
Add Rows based on Cell contents | Excel Discussion (Misc queries) |