Excel - data autofilter, then data sort how do you view all

[Peg]

Once you've selected the data auto filter and then data sort, how do you go
back and view all the original data. The data is still there, but now you
have to select the auto filter dropdown button to view the other data. Do
you know how to fix this?

 

[Dave]

Hi Peg,
The first choice on the AutoFilter drop-down is (All). Select this.
If your AutoFilter spans several columns, you may have to do it on each
column, although I think you just need do it to the last column you filtered.
Have I understood your question?
Regards - Dave.

 

[Gord Dibben]

That is normal.

Nothing to "fix"


Gord Dibben MS Excel MVP