In this article:

How to Unsort in Google Sheets (Easiest Way in 2024)

How to Unsort a Column in Google Sheets

To unsort a column in Google Sheets, you would ideally need to have a strategy in place before sorting, as Google Sheets doesn't have a built-in "unsort" feature. 

Here are some methods you can use to restore your data to its original order:

Method 1: Use Undo

Immediately after sorting, you can simply press Ctrl + Z (on Windows) or Cmd + Z (on Mac) to undo the sorting action.

Method 2: Create a Backup Column Before Sorting

Add a Backup Column: Before you sort your data, insert a new column next to your data.

Fill with Sequential Numbers: In this new column, fill it with a sequence of numbers (1, 2, 3, etc.), which will serve as an index of the original order. Below is an example:

how to unsort in google sheets

Sort Your Data: Perform your sorting on the desired columns. In our example, we want to sort the data in Column B alphabetically, so we would sort Column B from A to Z. 

how to unsort a column in google sheets
unsort a column in google sheets

Revert to Original Order: To revert to the original order, simply sort the entire dataset again based on the backup column with sequential numbers. Highlight the range again, including the indexing column. Go back to Data > Sort range. This time, sort by Column A (your indexing column), from A to Z.

can you unsort a column in google sheets

This will return your data to its original order.

Method 3: Use Google Sheets History

Google Sheets automatically saves different versions of your spreadsheet as you make changes. To access the version history, click on File > Version history > See version history. You can then select a previous version before the sort was applied and restore it.

can you unsort in google sheets

You can also simply click the clock icon at the top right to access the version history.

unsort google sheets

Note: The Undo feature and the indexing column method are the most straightforward. Always consider adding an indexing column before performing sorts if you anticipate needing to revert the changes. This method is proactive and can save you time and hassle, especially with large or complex datasets.

We hope that this article has helped you and given you a better understanding of how to unsort in Google Sheets. If you enjoyed this article, you might also like our articles on how to work out a suggestion mode in Google Sheets and how to add a watermark in Google Sheets.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started