| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
locking data/cells so re-sorting a column doesn't re-position my d
I need to re-sort a column, but I want all the row's data associated with
that row to stay with the SORT results. -- mtn_leisure |
|
#2
|
|||
|
|||
|
mtn_leisure Wrote: I need to re-sort a column, but I want all the row's data associated with that row to stay with the SORT results. -- mtn_leisure Try selecting the data in the other columns aswell and then sort the data should then stay together Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=396529 |
|
#3
|
|||
|
|||
|
Yeah, but if I select all cells how will I tell it which column to SORT by?
-- mtn_leisure "Paul Sheppard" wrote: mtn_leisure Wrote: I need to re-sort a column, but I want all the row's data associated with that row to stay with the SORT results. -- mtn_leisure Try selecting the data in the other columns aswell and then sort the data should then stay together Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=396529 |
|
#4
|
|||
|
|||
|
Once you've selected all the data, click Data Sort and then sort by whichever column, checking the box as required or not for a header row Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=396529 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Sorting data in a table by the header of a column? | Excel Discussion (Misc queries) | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
| Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
Linear Mode
