FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Once the data is filtered, you can delete only the filtered rows by selecting the filtered data and pressing the “Ctrl” and “-” keys on your keyboard at the same time. This will open the “Delete” dialog box. Make sure that the “Shift cells up” option is selected and then click the “OK” button.

Detailed explanation-2: -Go to the Data tab in Excel and click on the Filter icon. Click on the small arrow next to the needed column name, go to Filter by Color and pick the correct cell color. Click OK and see all highlighted cells on top. Select the filtered colored cells, right-click on them and pick the Delete Row option from the menu.

Detailed explanation-3: -Remove all the filters in a worksheet If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F.