HOW TO CREATE NORMAL DROP DOWN LIST IN EXCEL WITH DATA VALIDATION

HOW TO CREATE DROP DOWN LIST IN EXCEL 2013-2016


Now A Day Excel Is A Most Use Full And Help Full Software In Whole Class Level. Excel Can Use In Hr, Finance, Supply Chain, And More Important Department In Any Company And Also Use Shop Keeper, Store Keeper And All Small Busniess, Excel Also Use Professionals, Experts, Students, Learner Etc. Its Mean Microsoft Excel Is Most Useful Software In Our Life.

In this Article We Cover HOW TO CREATE DROP DOWN LIST IN EXCEL 

OUR DATABASE

EXCEL DATABASE


We will create Drop Down list From Name Column.

Step1:


Define The Range Name Of Name Column. How to Define Name Of the Range

Step2:


Go to Data Tab On the Ribbon and Click Data Validation Button in Data Tools Group. Data Validation Popup Window Open On Your Screen

Step3:

In Data Validation Popup Window, Allow List in Settings Tabs and input Name in Source Text Box and Click Ok Button

You Can Get Guide From Video


This Is The Newest Post


EmoticonEmoticon