Filter seems locked

  • Thread starter Thread starter SShelton
  • Start date Start date
S

SShelton

I was working on a spreadsheet and had only one filter utilized. I now
cannot remove it, even with going to data, filter, show all. I removed the
filters and now only the filtered rows appear. How can I now "unfilter" this
worksheet to again see all of my data?
 
Select all the rows that have data and then click FORMAT in the menu, select
ROWS and then click UNHIDE.

Hopefully this will solve your problem...
 
Thanks for your reply. I tried this and it did not work. I will keep
playing around to see if I can fix it.... Tx.
 
Back
Top