Forum Discussion
Mary_Xavier30
Oct 28, 2021Copper Contributor
UNABLE TO EXCEL SORT FUNCTION
I have attached an excel sheet I tried sorting column A & B but it does not get sorted.
1 Reply
Select cell A1, then click Sort & Filter > Custom Sort... on the Home tab of the ribbon.
Clear the check box 'My data has headers', and specify that you want to sort on column A, then on column B.
Excel will display a warning about column B. In this case, it doesn't matter which option you choose, so just click OK.