View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SShelton SShelton is offline
external usenet poster
 
Posts: 3
Default Filter seems locked

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.

"Kevin B" wrote:

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?