Case Sensitive Sorting in Excel
How to perform case sensitive sorting in Excel.
- Select a cell within the data that you want to sort and then go to the Data tab and click Sort
- In the window that opens click the Options button.
- Put a check mark next to the Case sensitive option and hit OK.
- In the Sort window choose how you want to sort.
Choose the column by which you want to sort.
- Choose Values for the Sort On option.
- Choose the order to sort by.
- Hit OK and that's it!
Notes
Download the accompanying spreadsheet so you can try this out yourself.
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Case-sensitive co...
Tutorial: How to compare text, numbers, and dates in Excel - including case sensitive text comparis...
Tutorial: How to sort a data set by multiple columns in Excel. This allows you to better organize ...
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Tutorial: How to sort columns of data in Excel. This is the same as sorting left to right. This wi...
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)