But as long as a cell in the range is selected it's a matter of only 2 clicks.ĪI: Artificial Intelligence or Automated Idiocy? Please mark Yes/No as to whether a Reply answers your question. Hi, I have a very simple vba code where i want to first clear all filters in the slicer. It's true that the cell selector must be on a single cell somewhere in the list (not necessarily the first row) in order to turn the Filter on again. Use Excel Slicers to select criteria, show matching records from list. There's no need to select the entire list of records beforehand. Likewise, choosing Filter in the Data menu to deselect it restores all records as well. ![]() No matter how many fields I filter on or how complex those filters are, a single click of the Filter icon itself (fat part of the button, not the arrow) turns the Filter feature off altogether &Īll records display. I can't explain the problem with the first suggestion, though. ![]() My instruction is to go to the Data menu in the Main Menu bar & select theĬlear Filter s command from there - Neither of the 2 button menus contains that specific command. As illustrated in your screen shot, you are trying to use the Clear Filter command from the Filterīutton on the Standard Toolbar, which is functionally the same as the Filter button on the
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |