Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
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.
00:09
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.
00:19
So, um,
00:21
let's go to the same file and as you see the sheet to is hidden. So let's first unhygienic it,
00:30
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,
00:42
and here you are in this sheet, so now you can do some protection. So let's, uh, let's go to file tab.
00:51
And then here we could con info. And here we have some options.
00:55
So we have a pro option to protect Workbook and er have several options of protection under protected workbook.
01:03
So
01:04
first of all, we can protect current sheet. Now, we're not protecting it from being seen.
01:12
Um
01:15
ah, we can protect it from being changed so we can click on protect current sheet
01:22
and, um
01:23
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
01:38
is goingto ask us to enter the
01:42
possibles again.
01:44
And now all these cells are protected. So if you want to change something here
01:51
we get
01:53
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,
02:01
you might be requested toe enter a password. So
02:07
we click here
02:07
and you see here we don't have any option to change this cell, so formal cells is not possible.
02:16
So we first have to un protect the sheet.
02:22
Me enter the password. So you will be entering passwords older time. If you if you're trying to do something like this
02:29
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,
02:38
and, uh,
02:43
we can click here and locked
02:46
and we say, OK,
02:49
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.
02:58
And now if we want to change this cell here, you get the message that it's locked.
03:04
But if we want to change this cell here,
03:07
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
03:22
and if you want to Owen hide it, it's still not
03:25
possible to protect that. And that is a thing that we're not going to be talking about today.
03:32
So
03:35
next step in
03:37
protecting workbook
03:39
is, uh, here
03:43
and you have the option to for it to be always open, read on Lee.
03:47
And if you select this
03:51
and then if you save this file
03:55
and you want to re open it,
04:00
so let's just make a new blank worksheet,
04:04
and from that sheet we're going to open
04:09
this one.
04:11
It's automatically opening because we still have it open. So let's ah, let's close this one.
04:17
Let's, uh,
04:24
now open it.
04:27
So we go to file, we goto open religious check. Yeah, we open it. So it's this
04:33
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
04:45
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,
04:53
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
05:03
so here it is. We have this.
05:06
We have this sheet.
05:10
Ah, and it's now open normally. So we go now to file,
05:15
and we have other options for protecting workbook,
05:19
which is
05:20
we can use it to encrypt it would password.
05:26
And what it does
05:29
is
05:30
you cannot open the file without the password. So
05:33
if you're,
05:35
um,
05:36
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.
05:46
And, uh
05:47
ah,
05:49
that's the way you can already considered in the separate email. So if somebody has intercepted that email.
05:57
It won't help them because they don't have the password.
06:00
So now we're going to save it.
06:03
And, uh, let's, uh, let's, uh, close it.
06:09
So let's, uh, open a new blank worksheet
06:14
on dhe. Let's go to this one
06:17
and just close it.
06:19
So we're here.
06:21
And now when we want to open this worksheet,
06:27
we need passwords,
06:29
toe access it. 123
06:32
And now we get the other message. They want to open it as read only.
06:38
And we at this point, we say no,
06:42
and
06:43
we get this.
06:47
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.
07:01
And, uh,
07:02
we could hear. And now again, another password for protecting the structure can be different than the other
07:10
passwords be used in this, uh,
07:13
file. And again, we're going to use 123 just to make things simple.
07:21
And now, if somebody wants to add
07:25
new sheet
07:27
or
07:28
tow the lead sheet,
07:30
it cannot be done.
07:33
You cannot hide in there. I'm Hyde.
07:38
So if we go now back to here
07:42
and we want to
07:44
protect the world would structure. We're now on protecting it.
07:47
And now if we can hide this one
07:51
and then we go back to here
07:55
and we protect the workbook structure with the password,
08:01
okay?
08:03
And now we save it
08:11
and we close it
08:15
and now reopen it.
08:20
It's protected with password. So you give this password, it's read only. So what's open? It is read only.
08:28
And now
08:30
I'm Heidi is not possible.
08:31
So we have protected it with passwords
08:35
and we have protected the Shiven
08:37
sheet passwords and this is finally the full protection of a file
08:43
and this is really good.
08:46
Now if we want to save it,
08:52
we cannot, because it's really only
08:56
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,
09:05
accidental changes. Hidden data are protected with the password. And also just to open this workbook,
09:13
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

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor