How do I Unsort in Excel 2020?

Below are the steps to unsort the data in Excel:
  1. Right-click on the left-most column.
  2. Click on the Insert column option. …
  3. [Optional] Add a header in cell A1.
  4. Add 1 in cell A2 and 2 in cell A3.
  5. Select both the cells (A2 and A3), place the cursor over the bottom-right part of the selection. …
  6. Click and drag.

Must Read

How do I get rid of the sort arrows in Excel?

Go back to your Excel sheet and select any cell. Select the View tab, click on the Macros menu on the far right and then choose the macro/code you’ve just pasted in. It should be the first one on the menu. Select it, click Run, and all the arrows will disappear from the table.