Removing an Advanced Filter

A

Annie1904

I've 'attempted' to apply an advanced filter to an excel document, but now I
can't remove it! The option for a normal filter is 'greyed out' and when I
clcik on advanced filter again, it just shows the parameters. Deleting these
returns an error, and I can't see to get rid of it at all. I just want to go
back to my normal, unfiltered spreadsheet. There must be a simple answer!
Can you help? Annie.
 
R

Roger Govier

Hi Annie

try Data>Filter>Show All

On my toolbar I have the Show All as an icon.
View>Toolbars>Customise>Category>Data>drag Show All to the toolbar>Close
 
A

Annie1904

Unfortunately, Show All is also greyed out. Only Advanced Filter is
available to select.
 
R

Roger Govier

Hi Annie

Ahs the sheet become protected?
Tools>Protection>Unprotect Sheet

If not, and you can't resolve the problem, you can email me the workbook and
I will see if I can see the problem.
To send direct mail to
roger at technology4u dot co dot uk
Do the obvious with at and dots
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=sum with a filter 2
Advanced filter 10
WORD VBA Search and switch to advanced ... 1
questions on advanced filter 4
Filter seems locked 2
Filter parameters asked on first open, subsequent unfilter/re-filterdoesn't re-fill the parameters 3
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Auto filter on blank lines 1

Top