Hello guys, Welcome to techknowlogic hub,
And today we are going to learn How to create a drop-down list in Excel,
Some time we need a drop-down menu for option, That's why I am going to show you How to
make a drop-down list in Excel, Let's take an example like your favorite
fruit, So this is the question,
And here will be the answer in drop down format, So first of all we have to make an item list
for drop down, Let's take fruit name,
Apple, Banana,
Grapes, Orange,
And mango, So this the item list of drop down,
Now we have to define a name for this item list,
Now select the all items, Right click over,
And click to the define name option, So this is the name window,
Give a name to this item list, Like I am going give to fruits,
Now hit the ok button, Now the list of items has made,
Here you can see the name of item list, Now choose a cell where you want to make drop
down, Like I want to make over here,
So click to the cell, Then go to the data tab,
And here you can see the data validation option, Click to the data validation,
In the setting tab, Click the drop down for allow,
Select the list option, Then put the source of item list,
Just write down the name of item list with equal sign,
Remember equal sign is compulsory to write down before item list name,
Hit the ok button, Now you can see here the drop down,
I am going to show you, Same as item list,
Select any one, Select another one,
So you can make drop down in excel like this, But keep remember one thing,
Don't make any changes in item list, If you make changes in item list then it will
change in drop down also, Like I am going to show you,
Write one, Now here you can see the changes,
If you make changes in item list then it will change in drop down also,
Once again I am going show you, Delete the value,
Here also deleted, So don't make changes in item list,
If want to remove item list from here so you can hide it from here,
And can use drop down, If you don't know how to hide cell, column
and rows, So you can see in the next video,
That's it for today, Thanx for watching,
Like, share and comment to the video, Subscribe to this channel for watching more
useful videos, Goodbye and take care,
Không có nhận xét nào:
Đăng nhận xét