How to sort only part of multiple columns in Excel

Solution 1:

The only solution I found is to cut and paste the highlighted portion to a new sheet and then sort it over there, once sorted copy/cut and paste it back to the original location.

Solution 2:

Yes, you can sort only a block. Just highlight the rows you want sorted, and it will sort only that area.

Note that if you receive this message:

then you have not selected all the columns in your table. As long as you don't get that message, then your sort will go as expected.

Solution 3:

If I understand your question correctly, you want to know how to do this with a Microsoft Office Application. And if it can be, which one? If that is correct, based on your last entry, you can accomplish the task using MS Excel 2010 by doing the following:

1. Select cells C5:D15
2. Using Excel 2010, click on "Home" in the menu bar
3. Click in the "Editing" tab, on "Sort & Filter"
4. Select "Custom Sort"
5. Uncheck the box "My data has headers"
6. Sort By: Column C
7. Sort On: Values
8. Order: A to Z
9. Click OK

Should you need to Sort Left to Right, instead of Top to Bottom, click the "Options.." button in the dialog box, to make that selection.

I have tested this with various numbers/data in all bordering rows and columns with success. And with only the data in the selected cells,rows,columns being sorted. All other data remained unchanged.