How to Remove Drop Down Lists in Excel (3 Easy Ways)



In this video, I will show you three easy ways to remove drop-down lists in Excel. I will also cover how to select all the cells that contain data validation rules.

00:00 Intro
00:20 Remove Drop Down Lists in Excel
04:23 Select All the Cells with Drop Down Lists (Data Validation Rules)
08:45 Enable Data Entry in Cells with Drop Down Lists

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –

✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:

Subscribe to get awesome Excel Tips every week:

#Excel #ExcelTips #ExcelTutorial

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
guest
2 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Surendran Nambiath

Thumbs Up 👍👍 Sumit! Thanks!
If you know any easy way to ADD Text not contained in the Source Listing, do post it here!
To take your last example, if you want to add Training not just to the Cell, but to the Source List too, without having to manually add it to the Source List, do let us all know!
Thanks once again!!

Alfonse Sang

Dope one bro