How to Unsort in Excel: A Step-by-Step Guide

Excel is a powerful tool that can help you organize, analyze, and visualize data. One of the most common tasks in Excel is sorting data. Sorting data can help you quickly find and analyze information in your spreadsheet. However, sometimes you may need to unsort your data to return it to its original order. In this article, we’ll show you how to unsort in Excel.

Step 1: Open your Excel file

First, you’ll need to open your Excel file. If you don’t have an Excel file, you can create one by opening a new Excel workbook.

Step 2: Select the sorted data

Next, you’ll need to select the sorted data that you want to unsort. To do this, click on the first cell of the sorted data and drag the cursor to the last cell of the sorted data. Alternatively, you can press “Ctrl+A” to select all the cells in the worksheet.

Step 3: Click on the "Sort" button

Once you have selected the sorted data, click on the “Sort” button in the “Data” tab. This will open the “Sort” dialog box.

Step 4: Click on the "Sort" button again

In the “Sort” dialog box, click on the “Sort” button again. This will bring up a warning message that says “You are about to sort a part of your data in a way that will remove the existing sort state. Do you want to continue?”

Step 5: Click on "Continue with the current selection"

Click on the “Continue with the current selection” button. This will remove the sort state from the selected data, effectively unsorting it.

Step 6: Click on the "OK" button

Finally, click on the “OK” button to close the “Sort” dialog box. Your data should now be unsorted and returned to its original order.


Sorting data in Excel can be a useful way to organize and analyze information, but sometimes you may need to unsort your data to return it to its original order. By following these simple steps, you can easily unsort your data in Excel and get back to working with your original data.