Filter

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

Don Niall

Help!!
I have just encountered a situation whereby I cannot
remove an autofiler that I had applied to a partcilar
spreadsheet? I have tried quiting/reloading spreadsheet -
but to no avail? It allows me to deselect the autofiller
in Data -> Filter, but has absolutely no impact on the
data? Has anyone encountered this, and if so how do I
resolve?

Don-
 
It does sound as if some rows are hidden independently of the autofilter.
To make sure that is not the case press Ctrl-a to select the entire sheet
and then do a Format, Row, Unhide.
 
Hi,

Is that particular spreadsheet protected? With password or
something? That could be one problem

Have you tried selection the WHOLE Row, go to DATA, than
autofilter and take it off?

Let me know if any of these work.
 
hey Don,

could it be that you accidentally tuned the auto filtered range into a
list?

is there a blue border around the range when you're in it?

if so select all the auto filtered cells and right click... in the
menu click list >> convert to range

that should get it back if this si the problem

brandon
 
Back
Top