All TalkersTech Sections

How To Add Drop Down Filter In Excel

Last Updated : Feb 14, 2022

How To Add Drop Down Filter In Excel

In this article we will show you how to add drop down filter in excel, excel is important for numerous data-keeping work. It is used extensively in offices for data keeping and having a proper track of transactions.

The usefulness of excel has been realized repeatedly in different sectors. So, it is in existence and used widely even after the availability of many other data-keeping methods.

It has always been a concern that if the length of the data is long then it gets complicated in excel. But the fact is with certain shortcuts and tricks, you can get the most out of excel. Knowing the tricks and shortcuts makes your excel experience smoother and easier.

Today we will look at the steps of adding a drop-down filter on excel. So, follow the given steps to add drop-down filter in excel file properly.

Step By Step Guide On How To Add Drop Down Filter In Excel :-

  1. Open the excel app on your device.
  2. Select the cells that you wish to add a drop-down filter to.

    How To Add Drop Down Filter In Excel

  3. On the ribbon section, click on data. It is the present on the top section.
  4. Once you click on data, it will show you many tools and functions that you can perform. There will also be a section called "data validation". So click on "data validation".

    How To Add Drop Down Filter In Excel

  5. Once you click on it, a dialog box will open.
  6. Click on "allow to list" on the dialog box.
  7. Click on "source" in the same dialog box.
  8. Type the text or numbers that you want on the drop-down list. Make sure that the texts and numbers in the source are separated by comma.
  9. Click okay. You will then get the drop-down list on the selected cells that you added the filter to.

    How To Add Drop Down Filter In Excel

Conclusion :-

If you accurately follow the steps mentioned above then you can easily add the drop-down list in excel. When you know how to add the drop-down filter, data entry becomes quicker and more accurate on excel.

It also limits the entries that people can make in a cell. So, you don't have unnecessary data to filter through in times of emergency.

When you want to add the drop-down list, just select the cell and the drop-down list automatically appears. You will just have to select any one option from the list and your answer will get recorded.

It is a hassle free and easy method of data entry without the input of unnecessary or incorrect data.

You get the accurate information and any confusion is avoided. With a proper drop-down filter added to the required columns, anyone can input proper data and the need for constant supervision is also removed.

So, just add the drop-down filter using the mentioned steps and enjoy the perks of using a drop-down list on excel. I hope this article on how to add drop down filter in excel helps you.

LATEST ARTICLES