hello and welcome to a new video
in this video we are going to learn
how to
insert password in excel file
so
before inserting password
we have to understand
two terms
read and write
what is the difference between read and write
read is
to read any file
for example
let me open this file
in this file
some data is there
i have read this data
like allahu is written
shivam is written, deepak is written
history is there in subjects
geography is there, math is there, sociology is there
so all this data
i am able to read
but what is write
if i am able to make some changes
in this file then
that is called write
now we will learn
how to insert password
when we insert password in any file
then it will not
open without password
second
you have this authority
what you want to give to user
you want to make him read
or you want to make him write
or you want to make him modify
these things are in whose hands
in your hands
now why is it necessary to insert password in any file
many times what happens
we work in organization
we have done important work there
but suppose
we forgot to insert password in that file
and that file
reached to some other person
and he made changes in that file
when he made changes
then all our data
all our hard work
went back to zero
so what is better
to take some precautions
and insert password in files
so
to insert password
what you have to do
suppose this is your file
you have to go to file
and save as
to save as you have to see
a location
we will browse
one more thing you have to remember
this is the location
where by default
your file is saved
we can change this
we will see how to change this
so now what i do
now where is this
in this pc
in c drive
there is a user folder
there is a folder
and desktop
in this desktop
it is saved
but suppose i don't want to save here
where i have to save this
i have to save this in d
so what you have to do
you have to go to d drive
and in d drive
you have to create a folder
i have created a folder
and i have written here
excel files
i have written excel files
now i have selected this file
you can see
this path has changed
here we have
saved it
we will put
file
4.xlsx
what is xlsx
file extension
what i do
i save it
so in this way
you have seen that we can change the path
along with changing the path
we see one more thing
save as when we do it again
now it is not taking the previous path
now it is taking the new path
now suppose i have to
put password on this file
here
you can see tools option
we will click on tools option
here we have
general option
when we click on general option
you can see
here
always create backup
we will talk about backups in next video
but before this
what is written here password to open
password to modify
to open any file
here i put
password
0987
what is mean by modify
modify means
you are writing in any file
and changing the data
here also i put password
09876
here
read only
recommended
if you click it
let's try
i read it
ok
now it is asking me
to confirm
the password
again
0987
09876
ok
now we save the file
save
file 4 already exist
we want to replace it
yes
now we close it
close it
and again
open it
let's try to open it
now see
what is written here
file 4.xl is protected
put the password
then only you can enter
we know the password
0987
ok
now it is asking
you put this password
but there is another password
which is
enter password to right axis
i want to write in it
i remember
ok
let's read it
click on read only
here
i can see
i can read it
i think
let's try
i put 10
it is happening
20, 30
ok
save it
save
it is saying
we can't save file because
the file is read only
you can't write
to write
you have to put password
so
what we do again
open this file
it is in read only mode
what we have to do
with read only
we have to write
don't save it
open it again
file 4.xl
password
0987
ok
the author
would like you to open
file as read only
there we have
read only
we can't write
data in it
let's create
another file
save as
browse
file 5.xl
now
put file 5.xl
go to tools
general options
remove read only
i can write
save
close it
open file 5.xl
here
password
0987
09876
now
we can
write
10
20
remember
last concept
save it
no warning
close it
save it
open file
file 5.xl
password
0987
09876
here
marks
we can write
how to protect
any file
with password
read only
write only
learn it
in today's video
practice till next video
if you have any doubt
you can watch this video
again