ChatterBank4 mins ago
Putting An Excel Spreadsheet In Alphabetical Order
32 Answers
I am currently listing a load of song titles on an Excel spreadsheet.
For some reason, it has issues with titles that start with the word 'Don't'.
When I click the A-Z facility, the list comes out more or less alphabetically, but some titles are thrown out of their alphabetical place and appear elsewhere for no reason that I can figure.
I have tried making a new list, but exactly the same thing happens.
Any ideas what's wrong, and how to fix it?
For some reason, it has issues with titles that start with the word 'Don't'.
When I click the A-Z facility, the list comes out more or less alphabetically, but some titles are thrown out of their alphabetical place and appear elsewhere for no reason that I can figure.
I have tried making a new list, but exactly the same thing happens.
Any ideas what's wrong, and how to fix it?
Answers
Best Answer
No best answer has yet been selected by andy-hughes. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.APG - // … click the icon on the left hand side that says 'sort and filter'(looks like a champagne glass with an A & Z.) choose 'custom sort' and the box I was referring to will appear, make sure you choose 'sort on cell values' and it should work. //
Thanks - but I have already done that, and it doesn't work.
Thanks - but I have already done that, and it doesn't work.
watch the whole thing through or skip to 0.29 to show you how to use custom sort.
https:/ /suppor t.offic e.com/e n-gb/ar ticle/s ort-dat a-in-a- range-o r-table -62d0b9 5d-2a90 -4610-a 6ae-2e5 45c4a46 54
https:/
Maydup - // Hoorah! odd how it occured in the new document too, but its solved and thats all that matters. //
Thanks - my vague curiosity about how the issue occured in a new document was rapidly eclipsed by my euphoria at having sorted it out - with some help from my tech friends on here, to whom, thanks again.
Thanks - my vague curiosity about how the issue occured in a new document was rapidly eclipsed by my euphoria at having sorted it out - with some help from my tech friends on here, to whom, thanks again.