Create Filtering Menu in Excel

August 31, 2024

In partnership with

Today, we will focus on creating a filtering menu in Excel, a powerful feature that allows you to sort and filter your data quickly and efficiently. Many of you might already be familiar with this feature or using it. If you're one of them, feel free to skip today's edition.

For those eager to Smooth their data management, let's dive into learning how to create a filtering menu in Excel.

All your news. None of the bias.

Be the smartest person in the room by reading 1440! Dive into 1440, where 3.5 million readers find their daily, fact-based news fix. We navigate through 100+ sources to deliver a comprehensive roundup from every corner of the internet – politics, global events, business, and culture, all in a quick, 5-minute newsletter. It's completely free and devoid of bias or political influence, ensuring you get the facts straight.

The process is as follows:

  • Open Excel and Press “CTRL + A” to select all the data

  • Press “CTRL + T” to insert Table

  • Select “Insert Slicer”

  • Select the desirable option for filtering menu, in this case “Status”

  • Change the Slicer Column for desirable filtering menu. In this case from 01 to 03

  • Set it at the top of the Table

  • Enjoy!!!

That’s how you can use filtering to make your data more accessible and easier to navigate. Whether you're managing sales data, customer lists, or project timelines, a well-designed filtering menu can improve the usability of your Excel data analysis.

Stay tuned for more Excel tips and tricks in our future issues. Happy filtering!