How To Add Filter In Excel: Hi friends! If you’re here, it means you want to learn How To Add Filter In Excel. This guide will show you a simple and easy ways to do it.
Working with big sets of data in Excel can make it tough to find the information you need. But Excel’s filter tool helps by letting you easily sort through the data and find what you’re looking for.
So, Let’s Start reading this guide without wasting any time!
How To Add Filter In Excel
Excel’s filter tool helps you quickly find the information you need. Let’s say you have a list of item sales. Here’s how to filter it:
1. Using Data Tab
Step 1: Click on the column header where you want to filter. For example, if you want to filter by item name, click the “Item” header.
Step 2: Click Data tab then click on Filter in Sort & Filter.
Tips: You can also use shortcuts like Ctrl + Shift + L or go to Home > Editing Group > Sort & Filter > Filter.
Step 3: After applying the filter, you’ll see drop-down arrows in the column headers. Click the arrow in the “Item” column to filter.
Step 4: Filter Options– The drop-down menu shows all items in that column. Uncheck the ones you don’t need and keep only you want (e.g., “LCD, KEYBOARD, DVD”). Click OK, and Excel will show only the sales for “LCD, KEYBOARD, DVD.”
2. Filter by Numbers
You can also filter numbers. For example, to find price of 4000 or less,
Step 1: click the drop-down arrow in the “Price” column, go to Number Filters, and choose Less Than or Equal To.
Step 2: Enter 4000 and click OK.
3. Multiple Filters
You can filter by both text and numbers. For example, to find price of “Item” over 12000,
First filter the “Item” column for “RAM,”
Then filter the “Amount” column for amounts greater than 12000.
4.Filter by Color
If cells are colored (e.g., red for over 12000 amount), you can filter by color. Click the drop-down arrow, go to Filter by Color, and select the color you want.
5. Advanced Filters
For more complex filters, use the Advanced Filter option. Copy your headers to a new area, add your criteria (e.g., “Oranges” and “Quantity >=5”), then go to Data > Sort & Filter > Advanced. Select your data and criteria range, and click OK.
Also Read: How To Add Degree Symbol In Excel
How To Clear Filter In Excel
Clear Filters: To remove a filter, click the filter icon in the column header and select Clear Filter. You can also go to Data > Sort & Filter > Clear.
Filters are a great way to focus on the data you need in Excel!
Also Read: How To Add Developer Tab In Excel
Conclusion
In conclusion, adding a filter in Excel is an easy and useful way to handle and study data. Filters let you sort, organize, and find specific details quickly without going through lots of information by hand. If you’re working with numbers, words, or colors, Excel’s filters make your work faster and easier.
Learning how to use filters can save time and help you make better decisions, making it a must-know tool for both professionals and students. Try using filters today to work smarter, stay organized, and get the most out of Excel.