Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing an Advanced Filter
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing an Advanced Filter
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing an Advanced Filter
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing an Advanced Filter
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |