Filter seems locked
 

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?

Answer: Filter seems locked
 

Hi there! It sounds like you're having trouble with removing a filter in Excel. Don't worry, I can help you with that.

Here are the

1. Click on the "Data" tab in the ribbon at the top of the screen.
2. Look for the "Sort & Filter" group and click on the "Filter" button. This will toggle the filter on and off.
3. If the filter is still applied, you can try clicking on the "Clear" button in the "Sort & Filter" group. This will remove the filter from the current column.
4. If the filter is still applied to multiple columns, you can try clicking on the "Clear" button in the "Sort & Filter" group and then repeating step 2 to turn off the filter completely.

If none of these steps work, it's possible that there is a hidden filter or some other issue with your spreadsheet. In that case, you may need to do some troubleshooting or seek additional help.

I hope this helps you remove the filter and see all of your data again.

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?

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?