Hello and welcome to a new video
In this video we are going to learn
how to find and replace something
and we have a very good thing
goto, how to use it
we are going to learn about these three things in this video
I have some data here
male, female, city
and here it is written January
if I scroll down, I have February data
I have March data, April data, May data
like this I have December data available
so what happens is
sometimes we type some things
then we realize later that this is a mistake
so what I have to do now
I have to go to every cell and fix that mistake
how to fix it? I have to go to every cell and change the
name
for example, here is Rahul
I have to write Ram instead of Rahul
now I have written Ram
let me show you the number of rows
I have 239 rows
you know how many rows I have
let me show you
I have a lot of rows
I have 1000 rows
so how can I go to every cell
but the problem is
if you go to every cell and edit it
it is not a good way
we have a good feature available in excel
we will use it
it is called find and replace
find and replace is available in excel
in last video, we have used short and filter
in short and filter, you will get
find and select
let me show you how it works
find, replace, go to, go to special
we will talk about find, replace and go to
we will talk about other options later
if I want to find and replace
I have one more option
shortcut is ctrl plus f
if I press ctrl plus f, you will see a dialog box
in this dialog box, you will see
find what
for example, I have put Rahul
and find all
here it shows me find and go
it shows me Rahul
it is showing me Rahul
it shows me Rahul
so find all means
i know where it is
so i can
know where it is
but i have to
replace it
so i close this
replace button
and click on ctrl
so here i can see replace option
so first you will see
what is written find what
so what you have to replace
i have to find Rahul
and with whom i have to replace
so what i do
i write Rohit
now you will notice
Rahul is written here
and here
so what should i replace
it should be replaced by Rohit
so what i do
i replace all
when i replace all
it shows me message
all done we made 24 replacement
so it means
we had 24 cells
in which Rahul was written
so what we did
we used a smart method
in 24 cells
to find Rahul
and replace Rahul
so it shows us
how many numbers
you have replaced
24 numbers
now i will show you
where Rahul was written
what is written there
you will see 14 number
so what is written in 14 number
Rahul was written
what is written there
Rohit is written
so when i come here
what is written there
Rohit is written
so if you see
this data
what you will see
Rohit is written
let's see again
for example
we have Shivam
let's replace with Shivam
so here
we go to ctrl plus F
or in this place
where Faridabad is
there i do
indore
so what i do
go to ctrl plus F
and replace
where it is written
Faridabad
with whom i replace
i replace
with indore
so i can see here
that my Faridabad
is written here
so i replace all
so here
it is written all done
we made 36 replacements
so 36 places
36 cells
where Faridabad was written
but what we did
in one second
we replaced all cells
with indore
so i think it is clear
let's close it
so now we know
how to find
things and how to
select and replace
now third thing
is
here we have
January February
March
April
June
July
but you notice one thing
if i want to see December
then i have to scroll down
for December
here
i have to bring it down
when i reach here
i will reach December
i want it not to happen
and if i put December
then it will come directly
without scrolling
and if i put November
then it will come without scrolling
so let's see this
what we have to do
like i want to see January
so i selected this cell
and right clicked
after right clicking
you will see here
define name option
so you will click
this option
here it is asking
what name you want to put
here January
ok
i think this spelling
is correct
the name already exist
name should be unique
ok
so
we have defined name
and here we have put
Jan
ok
so i put short form
when i put Jan
Jan means January
if i define February
then i put
Feb
ok
after that i put March
like this
the benefit of this
when you are doing everything in starting
then in starting
define name with data
so it will be easy for you to find
so for March i put Mar
ok
for April i put Apr
or define name
here i put Apr
like this
till December
for May i put May
because it is short
so i put May
after that
i put June
i think for June
we have to put same name
July
we have defined name
and we select it
now we go to August
for August we go to
define name
and for August we put AUG
and here we put
ok
now we go to September
for September
we have to define
all the data
we put ok
now i show you till September
there are only 3
we go to October
for October we put define name
and we put
OCT
November
for November we have to put
November and here we go on December
and on December
what is defined name
December
Now suppose I am here
on top
at the start
cells here
row 1, row 2
January section
I have to go to June section
what I will do
shortcut is
ctrl plus g
click on the control button
click on the plus button
so you can see here the data is already written
the shortcuts we have made
and also there is an option of reference
in reference option you can directly write the name
like if i want to go in june
so i put june for june data and click on ok
so you can see it reached june automatically
now if i want to go in january
so you can see here
like if i want to go in feb
so you can see it reached feb automatically
now suppose i want to go in december
so to go in december i have to click on control plus g
either i will come here and write december
or i can also select from here
from here i will select where is december
so it took me to december
so if i want to go in june
so what i will do in june
i will put june here
i will put april
so for april
the data of april was shown to me
so what we have to do in this video
we have to find a value
how to find a value
if you wrote a value by mistake
so it should not be like this
that we are going to a value again and again
and after that we are writing a new value
so this is not a smart way
in excel we have features available
so we should use them
so in this video i think we do this much
how to find a value
how to select a value
how to replace a value
from go to option
we can go to a particular section
so i think this is enough for today
see you in next video
till then you have to practice