Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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
Similar Content on TeachExcel
Exact Function - Case Sensitive Comparison in Excel
Tutorial: Case-sensitive comparison of two text strings or values in Excel. To do this, we use the E...
Tutorial: Case-sensitive comparison of two text strings or values in Excel. To do this, we use the E...
Sort on Multiple Columns at Once in Excel
Tutorial: How to sort a data set by multiple columns in Excel. This allows you to better organize ...
Tutorial: How to sort a data set by multiple columns in Excel. This allows you to better organize ...
Sort Data Left to Right in Excel
Tutorial: How to sort columns of data in Excel. This is the same as sorting left to right. This wi...
Tutorial: How to sort columns of data in Excel. This is the same as sorting left to right. This wi...
Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Hide or Protect a Tab in Excel - 2 ways
Tutorial: Two ways to hide worksheets in Excel. Method 1 You can create a little macro to assign a p...
Tutorial: Two ways to hide worksheets in Excel. Method 1 You can create a little macro to assign a p...