Question

in ms excel which option should be selected in order to arrange the data in any column or multiple columns​

Answer 1

On the Data tab, in the Sort & Filter group, click Sort. In the Sort dialog box, under Column, in the Sort by or Then by box, select the column that you want to sort by a custom list. Under Order, select Custom List. In the Custom Lists dialog box, select the list that you want.