Excel grays out menu commands for unavailable features or functions. To unlock the grayed-out menus, first review the most common causes, then take the steps necessary make the menu active. By default ...
Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.