CODEWITHSUNDEEP
excel
Roberto
Roberto

Reputation: 11953

How to clear Sort in Excel 2007

I put filters in some columns with numeric values and then used the "Sort Smallest to Largest" feature in one column. Excel sorts and changes the icon in the filter. How do I clean this sort? The sort option is inside the filter button (in the cell) but it seems that is not possible to clean the sort: the "Clean Filter From ..." is not enabled and the only way is to undo.

I want to sort, change data and sort back, and there is no other column that could be sorted to get back to the initial state.

Upvotes: 11

Views: 89201

Answers (5)

JP slash otterlover
JP slash otterlover

Reputation: 169

After using the filtering and sorting combination it's possible to reset those filters, in order to display the worksheet's initial state, by selecting the "Clear" function from the ribbon:

Home/Editing - Sort & Filter/Clear

Note that this does not return a table to it's original/initial sort order, but it does remove all filters and gets rid of any sort arrows in the table header.

*Also valid for Excel 2010

Upvotes: 16

Sreedhar S
Sreedhar S

Reputation: 1

If you have the date column in this sheet. You can clear the filter from the column where you want to undo sorting and come to date column and select sorting option to sort the dates from oldest to newest or newest to oldest to solve the issue.

Upvotes: -2

Gerhard Powell
Gerhard Powell

Reputation: 6185

For newer versions of Excel that uses Ribbons: Select Home, Editing. Click on the drop-down next to Sort & Filtering. Click Clear

enter image description here

Upvotes: 3

user3915241
user3915241

Reputation: 11

If the name of your file on the top of the Excel application shows "[Group]," then you might want to unselect to only the a single sheet on the bottom of tabs. Then try the unfilter.

Upvotes: 0

Tuco
Tuco

Reputation: 1630

You can create a temporary new column with sequential numbering, then ordenate the whole worksheet using the desired column, and then filter back using the temporary ordinated column.

Upvotes: 7

Related Questions