The Filter button will now be available The 'Equals' filter isn't working ![]() Just make your way down to one of your worksheets, right-click the sheet tab and then select Ungroup Sheets. If you can see 'Your file name' - Group you currently have worksheets that are grouped. You can tell if they are simply by looking at the title bar where the filename is shown at the top of the screen. If the Filter button is greyed out check that you don't have your worksheets grouped. This then leaves Filter turned on, but removes all filter settings allowing you to start again with the full set of your data. The best way to clear all of the filters is to click the Clear button on the Ribbon (to the right of the Filter button). ![]() Check for other filtersĬheck that a filter hasn't been left on another column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |