Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit so that the data maintains integrity within rows.

Usually when you sort ascending or sort descending it's by highlighting an entire column, and you're given an option to expand the selection, which would sort your entire spreadsheet based on the new order.

Am I able to sort only a block, without choosing the entire column?

share|improve this question
Try highlighting those 3 columns and sort by the required column (click the required column first when selecting), if that's what you're looking for. –  Jerry Sep 25 '13 at 12:42
You must apply the sort to the entire row of data that you are sorting for it to maintain integrity. So you can select rows 5-15 and select filter, then just filter by c d or e. –  Raystafarian Sep 25 '13 at 13:45

1 Answer 1

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:
enter image description here
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.

share|improve this answer
Sean, thanks for the comment. I think that won't work because if I include more than one column in that block, Excel won't do anything. Actually, I may have found a solution--Kingsoft office will sort the block by the left-hand column in that situation. Do you know of an office feature that will do the same thing? –  DubiousLenovo Sep 25 '13 at 23:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.