Forum Discussion

1 Reply

  • Mary_Xavier30 

    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.

Resources