Hi Annie

Ahs the sheet become protected?
ToolsProtectionUnprotect 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

--
Regards
Roger Govier

"Annie1904" wrote in message
...
Unfortunately, Show All is also greyed out. Only Advanced Filter is
available to select.

"Roger Govier" wrote:

Hi Annie

try DataFilterShow All

On my toolbar I have the Show All as an icon.
ViewToolbarsCustomiseCategoryDatadrag Show All to the toolbarClose

--
Regards
Roger Govier

"Annie1904" wrote in message
...
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.