How to remove data sorting 1 To remove data sorting on a column, level, or row, right-click a cell. From the menu, choose Sort. 2 In Sort, as shown in Figure 3-37, select None. Then choose OK. Figure 3-37 Sorting data on a column