Forum Discussion
Excel wont sort
Hi , for some reason my Mac excel has decided that it will not sort any data. Even a simple list wont sort and I do not know what I have done to suddenly experience this. I was trying different settings yesterday whilst looking for something and I fear that I may have inadvertently changed something.
Any ideas ?
Thanks
Justin
6 Replies
Perhaps som dumb questions, but what exactly are you trying to sort? And how? Is sorting not done at all or does it seem to be sorted incorrectly?
Perhaps you have leading spaces in your data or hidden (blank) rows in the range your are trying to sort.
Please upload some sample data. Am on a Mac myself since many years ago. Never came across this problem.
Thanks for the reply, I cannot share the actual data but here is a very simple example . I just put random numbers into a sheet and tried to sort them smallest to highest using the Sort function... this is what it did , basically nothing . It is the most simple function but for some reason it just isn't working ?
I assume you are going through the required steps to sort. I.e. select the range to be sorted and then select ascending or descending. Did sorting work previously? And since you say "random numbers", I assume that you keyed in these numbers yourself and that they are not based on a formula that contains RAND(). Just need to be sure about it.
