Excel tutorial

How to remove a drop-down list in Excel

By Explaino Team · Updated

Quick answer

So in this video, we will learn how to remove list from drop down. So as you can see here is our drop down as a picture. In short: Click on it; Or you can choose custom and simply click on the clear all. Watch the 2-step walkthrough below.

Watch: How to remove a drop-down list in Excel

Made with Explaino from one screen recording.

So in this video, we will learn how to remove list from drop down. So as you can see here is our drop down as a picture.

Step by step

  1. 1

    Click on it. Go to the data tab. Select data validation. And choose any another option. Aside list. I'm choosing anybody.

  2. 2

    Or you can choose custom and simply click on the clear all. Then apply. And here, drop down would be

Make your own Excel tutorial like this in minutes

Record your screen once. Explaino adds the voiceover, smart zoom and captions, and writes the step-by-step article with screenshots for you.

Free plan · no credit card required