In MS Excel 2010 version there is an option to unsort multiple/many columns in excel in one go: HOME->EDITING->SORT &FILTER drop down menu->CLEAR.
How do I Unsort in Excel 2020?
Below are the steps to unsort the data in Excel:
- Right-click on the left-most column.
- Click on the Insert column option. ...
- [Optional] Add a header in cell A1.
- Add 1 in cell A2 and 2 in cell A3.
- Select both the cells (A2 and A3), place the cursor over the bottom-right part of the selection. ...
- Click and drag.
How do I Unsort the original Excel?
Go to Home tab > Sort & Filter > Clear to clear the sorting/filtering. This will remove all filters to sort state and get rid of sort arrows.
