The second method requires a little coding. Using VBA to Hide Rows based on Cell Value Note: To unhide the hidden cells, simply click on the Filter button again. You should now be able to see only the rows with Employment Status=” In service”. You can simply uncheck “ Select All” to quickly uncheck everything and then just select “ In service”. Uncheck the boxes next to all the statuses, except “In service”.So, select the arrow next to the Employment Status header. In this example, we want to filter out the rows that contain the Employment status = “ In service”.You can click on any arrow to choose a filter for the corresponding column.
You will find it in the ‘ Sort and Filter’ group. Let us say you have the dataset shown below, and you want to see data about only those employees who are still in service. Using Filters to Hide Rows based on Cell Value
