filter

M

Misho

I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in
the original order.

how can I get it solved?
 
G

Gord Dibben

If you saved the workbook with the data sorted your only recourse is to dig
out the backup copy.

If you did not save, close without saving.


Gord Dibben MS Excel MVP
 
M

Misho

Hi Sean Timmons,

Thanks for your response,

I'm note sure, as my brother was working on it last week and save it.

and when I clear the sort and the filter, it doesn't returned to the order,
as there wasn't a reference to my data, as I was Depending on the Excel
reference
 
S

Sean Timmons

If data was sorted while filtered, it doesn't always sort the entire table.
Best thing you can do now is sort the data with the filter set to show all or
removed...
 
Top