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: www.mrexcel.com/youtube/Od5Iw...
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: www.mrexcel.com/products/latest/
#microsoftexcel #microsoft #exceltutorial #excelfilter
Welcome to another episode of Excel Hacks! In today's video, we're going to learn a new trick that I'm pretty sure you've never seen before. We'll be using the Filter Search box to remove items from our filter. This hack was shared with me by Melvin from Orlando during a seminar in Daytona Beach, and I have to say, it's a game changer.
As we all know, using the Filter box to find specific items is a common practice. But what if we wanted to get rid of a whole bunch of items? For example, let's say we want to remove all the items that start with the letter C in our Category column. Manually unchecking each item would be a tedious task. But with Melvin's trick, we can do it in just a few clicks.
Here's how it works. First, we type in the letter C in the Filter Search box, which gives us a list of all the items starting with C. Then, we select all the search results and click on "Select All Search Results". This effectively unchecks all the items starting with C. Finally, we click on "Add Current Selection To Filter" and voila! All the items starting with C disappear from our filter. It's that simple!
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
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
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...
14 июл 2024