Hello and welcome to our new video
In this video we are going to learn about Split Feature
What is Split Feature in Excel and how does it benefit us
In last video we talked about
Freeze Feature and in this video we are going to talk about
Split Window
How to use Split
So I open Excel and here you can see this is the same data
which we saw in last video
Now before using Split
Feature let me show you what problems we face
First problem is here for example this is Sociology Data
In Sociology Data you have to change anything
Let me select all cells and I have selected an extra cell
in which I will get output 5496 What is this?
All marks of Sociology
I have totaled 5496 Is it clear?
Now suppose someone told me to change marks of Harish or
Shyam or 60
First check this number 5496 If I change here marks of
Sociology should change to 5496
For example, I have changed marks of Imran to 90 and I have
entered
So what should happen? 5496 should change
So here it changed to 5508
Now someone told me to change marks of Hari Om
So I have changed it to 80 87 So here total marks changed
But problem is when I change here marks of any row or column
For example, if I change 33 then in real time
I don't get to know how much is positive or negative
I don't get to know
If it was possible
I would get to know 5549 So this split helps
Let me show you how to apply split
The way to apply split
For example,
My row number 12
From here
This is your window
Whatever screen you can see
I have to divide this window into two parts
So wherever I have to divide
For example,
I have to divide bottom portion of second window and upper
portion into first window
So what I will do?
I will click here
In any column
What can you do?
You can select
For example, I picked Imran
Then I split
When I split, you will see a highlighted line
This is highlighted line
Now if I scroll
You will see
This is scroll
Right? Now what is the benefit of this?
Let me show you
What is written here? 5549 Now someone asked me to change
the marks of row number 29 and show the real time
So I went here
When I
Row number 49 Row number 49
From 60
I made it 100
When I made it 100, it should change from 5549
I entered
And I got the real time 5589 Now if I want to change
Jishan's mark from 25
So what I did?
I made it 89
Then I entered
So here you can see that marks are changing simultaneously
When marks are changing simultaneously
You are getting the benefit
You don't have to scroll again and again to see the marks
You get the real time calculation So the biggest benefit of
split window is this
When you calculate any marks
In real time, you can make another window
Now the question is
Can we divide this window in more than one part?
Like we did in two parts
Can we divide it in four parts?
Yes, we can
One more thing to understand
When we divide the window in two parts
It means that all the data in the first window will be
visible in the second window
What does it mean?
Here serial number
Subject If I scroll down When I scroll down
You will see 100 marks 100 is the data
If I scroll down
You can see 100 marks 100 is the data
So what is the meaning of window split?
It means that all the data in the first window will be
visible in the second window
If I want to remove the split window
How to remove it?
To remove it
You have to go to the view tab
If it is open
You have to go to split and click it once
And it will be in its original shape
As it was before
Now the question is
Can I divide it in more than one part?
Can I divide it in four parts?
Yes, you can
Here are the total marks
What I have to do from here
I want
The area before python
Means This area
This area will be a window
And this area will be a window
Along with that
The area below 75 will be a window
And this area will be a window
Let's do it
I split it
When I split it
You will see the highlighted line
It is both horizontal and vertical
And here
In four parts
Whatever data you have
The data will be in both
Let's do it
I clicked it
You can see the data
If you want to see it from here
You can see it from here
It is clear
We don't prefer this
The problem is
You will get confused
If I remove it
How much data is there?
How many numbers are there?
If I move it
Too much confusion
We always prefer
If I have to calculate the marks
I will divide the window
I will divide it
You can see it
I will divide it
You can see it
You can check it
Clear?
I have found the benefit of split window
I have to remove it go here and click on split once and
this first one will come in shift as the first one will be
restored as it was seen before is this thing clear? so, now
what you have to do you have to practice by pressing ok, if
you have any confusion play the video again