6 hours 3 minutes
So in previous lesson, you have seen how we can hide sheets or parts of the sheets. Oh, meaning rows and columns within the sheet.
Now let's go further in protecting your your Excel file. Ea Ah, and let's talk about how you can protect some things in the street.
let's go to the same file and as you see the sheet to is hidden. So let's first unhygienic it,
and you click on the right click on every any sheet and you get the select and hide, and you get a list of sheets that are hidden so you cannot hide. She do,
and here you are in this sheet, so now you can do some protection. So let's, uh, let's go to file tab.
And then here we could con info. And here we have some options.
So we have a pro option to protect Workbook and er have several options of protection under protected workbook.
first of all, we can protect current sheet. Now, we're not protecting it from being seen.
ah, we can protect it from being changed so we can click on protect current sheet
so all the cells in this sheet will be automatically locked when we enter password. So we enter the one password that you should never use. It's 12 tree. But just for this demonstration, we're going to make it simple
is goingto ask us to enter the
And now all these cells are protected. So if you want to change something here
this message was settled. That cell you're trying to change is on a protected sheet. To make the change unprotected chair and protect the sheet,
you might be requested toe enter a password. So
we click here
and you see here we don't have any option to change this cell, so formal cells is not possible.
So we first have to un protect the sheet.
Me enter the password. So you will be entering passwords older time. If you if you're trying to do something like this
and then we can go to form its cells and then we have protection here and, for example, we want to exclude this cell from being protected,
we can click here and locked
and we say, OK,
and then we go again to protect sheet, we enter the password again and again, but that's the only way to make it safe.
And now if we want to change this cell here, you get the message that it's locked.
But if we want to change this cell here,
it's working. So we have protected some of the cells, not all of the cells. And she actually, all of the cells, they're protected unless we unprotected. So this one sheet is protected. But if we hide it
and if you want to Owen hide it, it's still not
possible to protect that. And that is a thing that we're not going to be talking about today.
next step in
is, uh, here
and you have the option to for it to be always open, read on Lee.
And if you select this
and then if you save this file
and you want to re open it,
so let's just make a new blank worksheet,
and from that sheet we're going to open
It's automatically opening because we still have it open. So let's ah, let's close this one.
now open it.
So we go to file, we goto open religious check. Yeah, we open it. So it's this
and we get this message. The altar would like you to open lesson 4.5 that excel a *** as read. Only unless you make you need to make changes
open is read only, and then we're going to say no because we're still going to be working on this for a while. But you said yes,
we would be able to change something, but they wouldn't be able to save it in that file, we would need to use saves, and I'm going to get that s o. But
so here it is. We have this.
We have this sheet.
Ah, and it's now open normally. So we go now to file,
and we have other options for protecting workbook,
we can use it to encrypt it would password.
And what it does
you cannot open the file without the password. So
sending it to somebody, you can send it, and then if they want to open it, you call them and tell them password with by phone.
that's the way you can already considered in the separate email. So if somebody has intercepted that email.
It won't help them because they don't have the password.
So now we're going to save it.
And, uh, let's, uh, let's, uh, close it.
So let's, uh, open a new blank worksheet
on dhe. Let's go to this one
and just close it.
So we're here.
And now when we want to open this worksheet,
we need passwords,
toe access it. 123
And now we get the other message. They want to open it as read only.
And we at this point, we say no,
we get this.
So now we want to go further and protection. We can click and file again again. Info. We get this protect workbook quickly here, and we can also use the protect workbook structure.
we could hear. And now again, another password for protecting the structure can be different than the other
passwords be used in this, uh,
file. And again, we're going to use 123 just to make things simple.
And now, if somebody wants to add
tow the lead sheet,
it cannot be done.
You cannot hide in there. I'm Hyde.
So if we go now back to here
and we want to
protect the world would structure. We're now on protecting it.
And now if we can hide this one
and then we go back to here
and we protect the workbook structure with the password,
And now we save it
and we close it
and now reopen it.
It's protected with password. So you give this password, it's read only. So what's open? It is read only.
I'm Heidi is not possible.
So we have protected it with passwords
and we have protected the Shiven
sheet passwords and this is finally the full protection of a file
and this is really good.
Now if we want to save it,
we cannot, because it's really only
so it automatically goes to save us. And now if we made any changes, we can save it, but under differently. So it's protected from, ah,
accidental changes. Hidden data are protected with the password. And also just to open this workbook,
we're protecting it with the password. Now we can protect hidden sheets from being opened. We doubt need to put a password on the file itself. So this is very important for you to understand. And this concludes this lesson
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered