Hello and welcome to our new video
What we are going to learn in this video
In this video we are going to learn about
Fill option
What does fill do?
Generally what is the meaning of fill?
Fill means to fill something empty
So in excel
What is the empty thing that we will try to fill?
Let's understand
So I open excel
Here I have given a marksheet type
In which 10 students data is written
Their marks are written of 4 subjects
Maximum marks
Then what is the total marks that they have obtained
Percentage is given, their grade is given and result is
given
Now where will we get to see fill option?
So for fill option
We have to go to the home tab
Home tab is already open here
You will go to the very last
Below the auto sum
You will see the fill option
What does fill option do?
Let's open fill option
So you will see
Down Right, Up, Left
Across worksheet
Now what is this across worksheet?
Which is disabled
And how to enable it?
After that there is series
After that there is justifies
And then there is flash fill
We will do flash fill in the next video
Completely But before that
All the other options
We will try to cover in this video
So one by one we will see
How these things are used
So first of all
Let's see here
What do I do in the marks of any subject?
I do total
Sociology, Geography, Computer Arts
I have been given marks of their subject
Because sociology is my favorite subject
So what do I do?
The marks of sociology
Let's do total
There is a simple way to do total
We know what is the way
All the
All the cells
I will select
One extra cell
And I have done auto sum
When I have done auto sum
I know the total 680 Now if I have to do
Geography marks
If I have to do Geography marks
What will I do?
You will say that do like this
And do auto sum again
I will say what is the need of this?
We have not seen an option
If we have applied the formula here
What to do after that?
What will we do?
We used to do like this
When we will drag this
What will happen?
What will happen on top of this?
Formula will be applied
This is the drag thing
By dragging
Fill the total marks of the subject
But if someone does not want to fill by dragging
Then how to do that?
We will tell you
Let's delete this
We have to delete these three
Let's delete these three
Now see
If someone does not want to do by dragging
What will he do?
He will select
Select one cell from this
And the remaining three cells
In which I want the total
I selected them
And then I went to the option of fill
And because
All the cells on the right side
I have to fill
So I went to the right
And I clicked on the right
And you will see
There are two ways
One is the way of dragging
What to do by pulling?
The second way is
I selected this cell
And selected the remaining cells
And what did I do by going to fill?
I did the right option
And all my other columns
Their total marks
The total marks of the subject
I got
Is it clear?
Let's go ahead
What is the main thing of fill?
This is also understandable
What is it?
The main thing
What is it?
We have to pay more attention to the selection
Not to drag
Pay more attention
So I
The remaining options
Like down, up, left
I'll show you
I'm here
Let's take a number
Like I took a number here
Let's take a random number 25 Now what I have to do
I have to
We have seen the right one
Let's see the right one again
I selected the right
And I have to fill
So where did I go?
I went to fill
Because there is no formula applied
So what will happen?
The number 25 will be filled
So we went to fill
Then I did the right
So what happened?
Now what I have to do
I have to down
So to down, I went here again
And I clicked on down
So what will happen now?
The down will be filled
Whichever cells I selected
And which were empty
What happened in that?
If I want to see the up one
I selected the cells
I went to fill
And I selected the up
So by selecting the up
The remaining cells which were empty
What happened? They were filled
If I want to do the same thing on the left
So what I have to do
The remaining cells on the left
Where I have to show this number
What will I do? I will select
I will go to fill
And what did I do? I selected the left
You can see how we filled the data
Let's delete this
After that let's go to the next option
I I I I I I I I I I I I I I I I I I I I I I I I I I I I I
I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I
I I I I I I I I I I I I I
I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I
I I I I I I I I I I I I I I I I I I I I After going to fill
No, I made some mistake
Let's do it again
I went to sheet 1
After going to sheet 1
Mesh
I pressed the shift button
Let's do it again
What I did again
I selected it
Then I pressed the shift button
And I selected sheet 6
After selecting sheet 6
What I have to do
I have to press the shift button
And after that
You have to click on the across worksheet option
When you click on it
It will ask you from here
What do you have in it
There are also formats in it
We understood in one video
What are the formats
I fill color in any cell
Or change the shape of my text
Change the font
All these are called formats
Now it is asking
What do you have to copy
You have to copy the content
What is the content
The names are written
Marks are written
What will happen in all
Content and format
Both things will be copied
What will happen in formats
I will show you
First I will show you all
I clicked on all
Now see
If I go to sheet 2
On sheet 2
It is automatically
On sheet 3
On sheet 4
On sheet 5
On sheet 6
It has been copied
Okay Now let's remove it
Control Z
Okay Came on the first sheet
All this is removed
Now we had to see this
Now I select again
How do you select
Press the shift button
The last sheet to be selected
Will do
Sheet 6
The rest of the sheets
Selected automatically
Okay Where did I go
Went to fill
And went to the across worksheet
Now here you will see
Content and formats
First I click on the content
When I click on the content
I click ok
So the color you are seeing
This color
Will not go in them
The rest of the sheets
You will see this format there
Let's do it
I did it ok
I went to sheet 2
You will see on sheet 2
I zoom it a little
On sheet 2
You will notice
As soon as the percentage was written here
This format did not come
Student name was written
Or sociology
You see
It was colorful
But did not come
Let's see in sheet 3
I zoom in sheet 3
So in the same way
The rest of the sheets
This is the same
Because what did we do
We just copied the content
We did not copy the format
I remove it
I undo ctrl z
Fine And we get there
Again Our first sheet
We go there
Now what will we do
We did this thing
Now we see
If we select the format
Then what happens
So what will I do again
I will press the shift button
And select sheet 6
The rest of the sheets
What will happen
It will be automatically selected
I went to the fill option
And what did I do here
Across worksheet
And here
What do I do
I select the format
And I do ok
Now I will go and see
On sheet 2
So you see
The color thing here
What happened to that color thing
This was the format
This format was copied
On sheet 3
This format was copied
On sheet 4
On sheet 5
Ok On sheet 6
So this format
What happened
Copied And in content
We saw
Content is copied
And when we do all
What happens
Content and format
Both things are copied
Fine I remove it
From ctrl z
Again Fine And we go to the first sheet
Our
Delete it
After this
What option is left
We have films
Series option is left
What does this series do
Let's see
For series
What will I have to do
For series
Let's take a new sheet
Fine Here sheet
Already So I took sheet 2
Let's zoom in a little
Fine
What do I do
I put any random number here
Like I put 7
Both numbers
Fine And after going here
What do I have to do
You must have seen series
Like If I
Talk about a series
Like 1,2,3,4,5,6
What happened
Series Fine Series of numbers
Or if I talk about series of even numbers
What happened 2,4,6,8,10,12 What happened like this
Series of even numbers
If I talk about series of odd numbers
What happened 1,3,5,7,9 What happened like this
Series of odd numbers
So now
If I have to create a series here
So see
I put 7 as a number
What did I do after that
Selected from here to here
That so many of my cells
There should be a series
Fine So after selecting
I went to fill
And I went to series
So series is showing me the option
Here series
Their option
Type option
And date unit option
Date unit option
Is disabled now
When we work on date
Then we will see
How to work by enabling it
Fine Now it is saying
Here is an option of trend
We will also see the option of trend
How does it work
Step value
And stop value
Fine First of all
Let's understand this thing
In type
Linear and growth are given
Linear basically means
Plus Fine There is 7
Like here
Step value is 1
Step value 1
Means That When I write step value 1
And type linear
Select So it means
Plus In 7
There will be 1 plus
There will be 8
There will be 1 plus
There will be 9
In 9
There will be 1 plus
There will be 10
Fine If I do growth
So growth means
Multiply Fine Here I write 1
Here I do growth
So here 7 multiply 1 7 7 multiply 2 14 In this way
It will move forward
Fine Let's do it
As I did
First I want columns
Fill in columns
And I selected
Selected linear
From here
I put step value 1
Instead of 1
I put 2
Fine 7 plus 2 9 9 plus 2 11 In this way
It will be filled
And I put
Step value
Stop value 20 Fine Means Stop value is
Where my series
Will stop
Fine And what I do
I do ok
And here
You will see 7 9 Let's zoom it 7 9 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
59 60 61 62 63 63 63 63 63 63 63 56 67 68 69 70 71 72 73 74
74 75 76 76 72 74 72 73 73 32 32 32 32 32 33 33 3 3 2 1 so
step value is 13.46 so what will happen in trend when i
selected trend stop value is disabled step value is also
disabled because i have given stop value 100 so what will
it do in between it will
percentage like this 720.33.46 60.73.86 like this it will
show so we have understood trend now let's see other
options if i go to series like date let's put current date
07 february 2023 ok let's increase size let's see date date
short date after this i have selected all i have to
increase date now how to increase let's see date now i have
to day day means after 7 8 february 9 february 10 february
like this i have done 8 february 9 february 10 february 11
february like this after this let's see
option next option let's see weekdays weekdays means when
you remove weekend means monday, tuesday, wednesday,
thursday, friday so now how it will show me 7, 8, 9, 10 now
it will show according to calendar like today is 7th
february today is tuesday so it will show me wednesday,
thursday, friday means it will show me 7th tuesday, 8th
wednesday 9th thursday and 10th friday after that it will
show me 13th let's see here after 10th it shows 13th
because it removed weekend after that it shows 13th,
15th 16th, 17th then it shows 18th, 19th it removed those
also so for this thing what does weekdays do after that I
go to fill again then I go to series now it shows month
month means from 7th february it will show 7th march then
it will show 7th april 7th may, 7th june, 7th july it will
show like this so I did ok here you will see 8th february,
9th february
I did wrong
I removed it again and I go to fill and I did month and
month should be from 1st so it shows 7th march 7th april,
7th may 7th june, 7th july it shows like this it shows
month wise it shows month wise let's remove it ctrl z now
let's go to series next option is year year means it shows
2023 7th february, 2024 7th february, 2025 7th february,
2026 it shows one by one but I don't want step value to be 1
I want it to show like this after 2023, it shows 2025 after
2025, it shows 2027 after 2025, it shows 2029 so what I do
I write step value as 2 and I do ok after 23 it shows 24
because I wrote step value as 2
I increased from 2 then it shows 25, 27, 29, 31, 33, 35 29,
31, 33, 35 clear after that next option is next option is
justify what does justify do it shows fill justify let's
delete it let's delete it let's delete it
we know that the size of our cell if we write bigger thing
it will show like I write here let's write capital this is
Rahul Rohila this is Rahul Rohila so you will see in column
F in column F in column F some things are there which
should not be there so fill justify does that it will
remove useless things so I select it
I selected this much and I said justify text will extend
below selected range text will extend below selected range
text will extend below selected range in same column so
what I did this is Rahul Rohila so in this way you can do
things if you see something outside your column outside
that particular cell so you can use justify and bring it
below like we make it bigger this is Rahul Rohila
so write it
write it again
this is Rahul
and we do party ok we do party this one where will it ends
because now it is going to the cell of column F and it is
going to the cell of column G so I selected it and I went
to fill and I said justify so text fill action below
selected range
I said ok so you see this is Zahul Lohila and we do party
now if I increase the size of this column from here then it
will go up ok in which case it will go up? in that case it
will go up till we have not selected justify ok but when we
selected justify once then it will not go up in that case
so remember this thing ok like if I remove this and write
it again see let's make it a little smaller size and here I
write this is Rahul Rohila and we do party ok we do party
here I selected it after
what I did from here we know that if we increase the size
of this column then it will adjust in this line ok we have
seen this also and if we decrease its size then what we
have to do? we have to select it and go to fill and justify
which will come in columns below ok is this thing clear? so
that's all in today's video ok if you have any doubt then
you can play the video again you can see