Question

how will you accomplish case sensitive and column wise sorting​

Answer 1

Answer:

Below are the steps to sort data alphabetically as well as make it case sensitive:

1.Select the entire dataset.

2.Click the Data tab.

3.Click the Sort icon. ...

4.In the Sort dialog box, make sure my data has headers is selected. ...

5.Click the Options button.

6.In the Sort Options dialog box, check the 'Case sensitive' option.

7.Click OK.

Answer 2

Explanation:

This Tutorial Covers:

Accessing the Sorting Options in Excel

Sorting Data in Excel (Text, Numbers, Dates)

Sorting by Cell Color / Font Color

Multiple Level Data Sorting

Sorting Based on a Custom List

Sorting from Left to Right

Case Sensitive Sorting in Excel

Getting the Original Sort Order

Some Common Issues While Sorting Data in Excel

Partial Sorting (Based on the Last Name)

Other Sorting Examples (Using Formula and VBA)