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

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?

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

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.

"Peg" wrote:

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?

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

That is normal.

Nothing to "fix"


Gord Dibben MS Excel MVP

On Wed, 23 Apr 2008 11:30:01 -0700, Peg wrote:

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?