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.

For some reason, when I try to sort in a file I downloaded, the sorting fails, even if there are just simple numbers in the cells. Editing is enabled.

What is going on?

Edit: When I say sort, I mean the following:

  1. Select the range I want sorted
  2. Hit the sort button
  3. Select the column that I want it sorted by
  4. Watch as the range remains unchanged.

Edit 2: The range is not quite unchanged. 5,1,2,3,4 is the least to greatest, and 3,4,5,1,2 is greatest to least. The latter order was the one that the data was entered in.

share|improve this question
1  
We need more information. An example of what you are working with would be really helpful. –  Jay Dec 28 '11 at 19:38
    
It's really that simple. A random spreadsheet, no special formatting or protection, with a simple column of numbers. It won't sort. Nothing else to say really. –  soandos Dec 28 '11 at 19:40
    
you need to select all cell you want sorted –  ratchet freak Dec 28 '11 at 19:43
    
@ratchetfreak, see edit. –  soandos Dec 28 '11 at 19:49
    
Just curious, when you say it fails, do you mean nothing happens or you do get a excel error message? –  Jay Dec 28 '11 at 19:50

2 Answers 2

I think excel does what you ask for exactly! If worksheet contains some empty rows, excel sorts until it encounters an empty row, and values after this empty row sorted again. I mean; assume we have column like this

5
empty row
6
3
1
4

excel sorts this row like this;

5
empty row
1
3
4
6

However, this problematic empty row generally created by copy/pasting operations, especially selecting two table from a web page.

By the way, sorry for my poor english :(

share|improve this answer

Click the sort button.

Is the "Sort on" set to Values?

Is the "Order" set to Smallest or Largest - and especially not set to a custom list? (Perhaps also check in custom lists and delete any list that may interfere)

Check the cell type of your cells, are they all the same type, like Numeric or Text?

Others are suggesting trying it on a different spreadsheet. What about on a different column in the same sheet? Try Copy+Paste, and Copy+Paste Values. Any difference?

share|improve this answer

Your Answer

 
discard

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.