Hello and welcome to a new video and in this video we are
going to learn about list sometimes your mom send you to
get coriander and with coriander she ask you to bring chili
and after chili when you reach the gate she ask you to
bring ginger so now the number of items increases so what
you need is to take a white paper and write items on it on
first number you have to write coriander on first number
chili on second number and on third number what you have to
bring ginger so what you have done
numbers like this so this is kind of list so we are going
to learn this in today's video and with this we will also
see that how we can make our custom list so let me open
excel before that if i tell you that you have to enter data
from 1 to 100 so you will say sir we will do 2 press 1 then
enter 2 then 3 then 4 then 5 till when you will do till 100
if i tell you to do till 1000 then how you will do you will
do like this 6,7,8,9 don't do like this let me tell you a
trick that how to make a list
here remove these numbers remove 3,4,5 ok what i have to do
if someone tell me that i have to write count from 1 to 100
i have to write roll number from 1 to 100 i have to write
roll number from 1 to 50 so i will use my smart brain and
what i will do i wrote 1 then i entered and now what i will
do i will select both and when i will write second cell i
will write bottom right corner so i can see a plus sign
what i have to do on this plus sign i have to take cursor
of mouse when the plus sign
i have to press left button and drag it down and where you
will leave the drag suppose i left it here ok so see all
the counting is done ok let me zoom it see
1,2,3,4,5,6,7,8,9,10 11,12,13,14,15 everything is written
so this is a smart way but always remember that you have to
put data in atleast 2 cells otherwise what will happen
suppose someone is trying to become smarter than you and he
is saying i have put data in 1 cell and now what i will do
i will see the plus sign i got the plus sign now
drag it now what will happen now it will put 1111 so what
you have to do 1,2,3,4,5,6,7,8,9,10 like this so what you
have to do atleast in starting 2 cells you have to put data
is it clear ok now suppose i have to put month name so i
put here january enter and then i have to do february after
entering february i have to put march we don't have to do
this much what we have to do select both the cells and see
the plus sign i have to drag it down and what is this
automatically filled what is this
let's do one more exercise days start from sunday so what i
have to do put sunday after that enter monday not monday
spelling of monday is wrong now what i have to do select
both the cells and see the plus sign and drag it and how
much i have to drag sunday to saturday if i drag more then
it starts in loop after saturday sunday then monday then
tuesday so it will repeat what we have to do increase the
size of column now suppose someone ask you like guest come
to your house and ask you to tell
now 20 21 21
21 21 21 21 21 21 31 31 31 31 31 I left it and look here my
31 table is ready
Isn't it interesting?
So what is this? It is a list
If you want to put a roll number
What can you do?
In this way 1 or 2
Put data in two cells
You drag it
Automatically the rest of the data will come
You have to generate a cell
You have to generate a table in this way
You can also generate that table
Of any number
You have to put data in two cells
In starting
Otherwise If you put it in one cell
It will take all the common names
The name of the first cell
Will come in the name of the rest of the cells
So this is the list
Now let's see how to create a custom list
So what I have to do
I have to go to the file menu
We went to the file menu
Now I went to the options
After going to the options
I have to go to the advanced option
You can see this
I went to the advanced option
And here I have to see
Where is the general heading
So I will scroll down with the mouse
And when I come down
So I can see here
This is written in general
I have to see in general
It is written here at the bottom
Edit custom list
I click on it
Now see here
This is the list that is already available
But what I have to do
I have to make a new list
Now how do I make a new list
What did my mother tell me
I have to bring coriander, ginger
I have to bring all these things
So what will I do
I make a list here
I put it here
Coriander After that
Ginger
After that
She told me for apple
And what did she tell me
She told me to make
Now all these things
It is added to a list
Now what I have to do
I have to add it from here
When I added it, it was added here
Now what I have to do
Ok What did I do here
Now see
When I put it here
Coriander After that
Enter and ginger
Now what I have to do
I have to select both
I have to sign plus from here
Did you see magic
This automatically
The rest of the items
In the list
She picked it up from there
This thing is understood
Now let's see
How to import data from a custom list
From any other file
Like this file
We have
There is a list in this file
Name list
Subject So this list
How to import
Ok How to write
We will see
We have to go to the file option
Where did we go from here
Options Advanced General General General Where did we go
Edit custom list
What do we have to do from here
Import Import list from cells
We have to tell
From which cell to which cell
We need data
Make a list
We have to click here
Custom list
Suppose We need this list
History, Geography, Math, Sociology
Total Rahul, Imran, Jishan
What do I do
Select from here to here
After that
What do I do
It came here
What did I do here
All these things
Imported in the list
Now what do I do
Ok Now suppose
I need this list again
So what I should know is the data of the two cells at the
beginning
Let's do it here
Like what I have to put first
I have to put Rahul
After that I entered
After that I have to put Imran And after Imran I have to
select these two cells
And from here as soon as the plus sign comes, I have to
drag it
And see this I have imported the whole list
What have we done
The data from any other file
We can also do that
We can import And in any of our files
By putting the data of the two cells at the beginning
We can import the whole list
Is it clear? See you in the next video
Till then keep practicing