Microsoft Excel Tutorial: How to use Excel’s Filter Search Box to remove items from Filter.

Melvin from Orlando shared a great Excel trick with me during yesterday’s live Power Excel seminar in Daytona Beach.

To download the workbook from today: https://www.mrexcel.com/youtube/Od5IwswzWnI/

We all know you can use the Filter drop-down Search Box to find all cells that contain Apple. But what if you want everything that does not contain Apple? Rather than use the old Text Filters for Does Not Contain, you can use this great trick from Melvin:
1. Search for Apple
2. Uncheck Select All Items
3. Check Add Current Selection to Filter
This applies a “Negative” filter to the current filter, removing items.

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

#microsoftexcel #microsoft #exceltutorial #excelfilter

Table of Contents
(0:00) Problem Statement: Remove anything that contains Apple from Filter in Excel
(0:15) Search Excel Filter for Apple
(0:30) Filter out anything starting with C
(1:18) Does Not Contain Text Filter
(1:46) Filter out anything starting with B and Apple
(2:02) Remove apple or berry from same column
(2:34) Did you know this?
(2:45) Wrap-up, Subscribe, Like, Ring the Bell