0
Yes, in Excel 2007 and higher, you can do a Case Sensitive sort.
- On the Data tab, in the Sort & Filter group, click Sort.
- In the Sort dialog box, click Options.
- In the Sort Options dialog box, select Case sensitive.
- Click OK twice.
See related links for more sort options.
Add your answer:
Earn +20 pts
What setting on a computer or program might affect the sort order of electronic records?
There is a "Sort Option" in Word and Excel that would allow the program to sort by "Case sensitive" (UPPERCASE versus lowercase) criteria. Access ignores the "case" when sorting.
How do you sort in Microsoft Excel?
Highlight the cell range you want to sort and click on the sort button. For Excel 2007, it is on the Home menu ribbon in the Editing section (on the right side of the ribbon).
How do you order numbers in excel?
Highlight the cells you want to sort and click on the sort button.
What XSL element can you use to sort or order your XML data?
Assuming "XLS" means MS Excel, you can import your XML data to Excel, then filter or sort as desired.
How do you sort out excel typing errors?
If by "sort out," you mean find and correct, then use the spell checker.
Can you sort files in ascending and descending orders?
no only data can be sort from the excel sheet.. not in the file
How do you sort linked data in excel?
You are able to sort linked data within any Excel document. If an error does occur check each columns formula so there Is agreement.
Excel' sort 'option available in which menu?
The Data menu.
How can you sort data in excel with more than 2 columns?
Select Custom Sort and add as many sort levels as you like.
Why do you use Sort Data function in Microsoft Excel?
The sort feature allows you to look at the same data in different orders depending upon what information you seek. Excel allows you to sort by date, sort by text or numbers, sort by multiple columns, like listing values from highest to lowest or names in alphabetical order.
The Group and Sort button is found on which tab?
The sort button is on the Home tab. I am not aware of a group button in Excel.
What feature used to rearrange data sequence in Excel?
The Sort feature.
