View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Filter seems locked

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...

--
Kevin Backmann


"SShelton" wrote:

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?