Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows
This is proabably simple and I'm just not seeing the obvious.
I have a spreadsheet with numerous columns of data. The second column contains names. I want to sort the spreadsheet by name but maintain the data integrity of the entire row when it sorts. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows
Bernie
Highlight all the data before sorting -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Bernie R." <Bernie wrote in message ... This is proabably simple and I'm just not seeing the obvious. I have a spreadsheet with numerous columns of data. The second column contains names. I want to sort the spreadsheet by name but maintain the data integrity of the entire row when it sorts. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows
Did that and it didn't work. Thought that was the correct procedure but this
spreadsheet has been everything but cooperative. Thanks for the reply Nick. "Nick Hodge" wrote: Bernie Highlight all the data before sorting -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Bernie R." <Bernie wrote in message ... This is proabably simple and I'm just not seeing the obvious. I have a spreadsheet with numerous columns of data. The second column contains names. I want to sort the spreadsheet by name but maintain the data integrity of the entire row when it sorts. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows
Did that and it didn't work.
I'm not sure whether you tried selecting all the cols involved, eg selecting cols A to E (say) then clicking Data Sort Sort by Col B* Ascending OK *your "Names" col -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows
Thanks Max. Tried that too and it still didn't maintain row integrity.
We'll just have to make do because we have to validate soldier's data for deployment today and tomorrow. It's a minor nusance but manageable. I know your advice and Nick's work on other spreadsheets that I have created, but these were forced on us and they are linked to 4 other worksheets and 2 workbooks. Appreciate everyone's assistance! "Max" wrote: Did that and it didn't work. I'm not sure whether you tried selecting all the cols involved, eg selecting cols A to E (say) then clicking Data Sort Sort by Col B* Ascending OK *your "Names" col -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows
Aha, you didn't tell us that the data is brought over from elsewhere via
link formulas. If you were to kill/freeze all the formulas on the sheet (you could do this easily in a couple of seconds by copying the entire sheet with the links, then do a paste special as values (& as formats) in a **new** sheet. The sorting should work fine in the new sheet. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bernie R." <Bernie wrote in message ... Thanks Max. Tried that too and it still didn't maintain row integrity. We'll just have to make do because we have to validate soldier's data for deployment today and tomorrow. It's a minor nusance but manageable. I know your advice and Nick's work on other spreadsheets that I have created, but these were forced on us and they are linked to 4 other worksheets and 2 workbooks. Appreciate everyone's assistance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting rows into a row | Excel Discussion (Misc queries) | |||
Sorting Rows | Excel Discussion (Misc queries) | |||
Sorting Rows | Excel Worksheet Functions | |||
Sorting rows | Excel Worksheet Functions | |||
[sorting rows] | Excel Worksheet Functions |