Forum Discussion
Irregular Sorting in Excel
I am having a very strange issue. The SORT result of a Data Column in an Excel file is incorrect when I sort using my Windos Laptop. However, when I do the same sorting function from another computer ...
Select one cell in the column you want to sort.
Press Ctrl + A, to select the entire region.
Check the selected area, to make sure that all the data is included.
On the Excel Ribbon, click the Home tab.
In the Editing group, click the arrow on Sort & Filter.
Click Custom Order.
Press Ctrl + A, to select the entire region.
Check the selected area, to make sure that all the data is included.
On the Excel Ribbon, click the Home tab.
In the Editing group, click the arrow on Sort & Filter.
Click Custom Order.