Advanced Filter - Show All doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used Advanced Filter (show unique records only) on a list of ~2700 records
of which about 20 were unique. I had copied the data to a new sheet then
filtered it (I did not chose "Filter in new location"), resulting, as
expected, in several "hidden" rows. I then realized that this was the wrong
set of data, so I deleted the column holding the data. Now, for whatever
reason, I cannot "unhide" the rows that were hidden when I executed the
filter. I have tried Data->Filter->Show All; highlighting the rows and
selecting "Unhide"; highlighting rows and changing row height. Nothing is
working.

The only thing that does work is individually changing the row height by
dragging the cursor from the bottom of the hidden rows.

Any ideas?
 
You deleted the filter range, so Show All won't be available.

To show all the rows --
Press Ctrl+A, to select all the cells
Double-click the border between any two row buttons
 
Thanks Debra. I found that using Auto Filter on a different colum and
selecting show all works as well.
 
Back
Top