View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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?