1
00:00:00,05 --> 00:00:02,04
- [Instructor] If you'd like to protect an Excel file,

2
00:00:02,04 --> 00:00:04,00
there's two options.

3
00:00:04,00 --> 00:00:07,00
The first one is entire workbook coverage.

4
00:00:07,00 --> 00:00:08,06
If you lock down a workbook,

5
00:00:08,06 --> 00:00:11,04
nobody can accidentally or deliberately change,

6
00:00:11,04 --> 00:00:14,08
delete, move, or rearrange worksheets.

7
00:00:14,08 --> 00:00:18,03
To do this, you can change to the Review tab

8
00:00:18,03 --> 00:00:22,04
and click Protect Workbook.

9
00:00:22,04 --> 00:00:23,07
You can put in a password

10
00:00:23,07 --> 00:00:25,04
(keyboard clacking)

11
00:00:25,04 --> 00:00:28,00
and click OK.

12
00:00:28,00 --> 00:00:30,03
You have to reenter it, which is good.

13
00:00:30,03 --> 00:00:32,03
(keyboard clacking)

14
00:00:32,03 --> 00:00:36,03
Click OK again, and the workbook is protected.

15
00:00:36,03 --> 00:00:39,04
If anybody comes in here and right clicks,

16
00:00:39,04 --> 00:00:41,09
you'll notice that all the important ones are grayed out,

17
00:00:41,09 --> 00:00:45,02
such as inserting, deleting, renaming, and moving.

18
00:00:45,02 --> 00:00:49,09
They also can't hide or unhide a sheet.

19
00:00:49,09 --> 00:00:54,06
I'll click Protect Workbook again and turn it off.

20
00:00:54,06 --> 00:00:58,02
(keyboard clacking)

21
00:00:58,02 --> 00:01:00,03
As long as I don't turn it back on again,

22
00:01:00,03 --> 00:01:02,03
it's still unprotected.

23
00:01:02,03 --> 00:01:04,02
The second way to lock down a file

24
00:01:04,02 --> 00:01:07,07
involves fine tuning cells or columns on a sheet.

25
00:01:07,07 --> 00:01:09,09
It's called Protecting the sheet.

26
00:01:09,09 --> 00:01:13,08
It gives you more options, but it is a two-step process.

27
00:01:13,08 --> 00:01:17,04
The first step is to unlock what the users can access,

28
00:01:17,04 --> 00:01:21,04
and the second step is to lock down what they can't change.

29
00:01:21,04 --> 00:01:23,01
I'm going to unlock everything

30
00:01:23,01 --> 00:01:26,01
and then only lock down the things that I want.

31
00:01:26,01 --> 00:01:29,01
I'll select the top left hand side of the Excel worksheet

32
00:01:29,01 --> 00:01:30,07
to select everything,

33
00:01:30,07 --> 00:01:33,03
and then I can right click on any cell

34
00:01:33,03 --> 00:01:36,04
and choose Format Cells...

35
00:01:36,04 --> 00:01:39,01
Now I'm going to go over to the Protection tab,

36
00:01:39,01 --> 00:01:40,06
and if you've ever been in here

37
00:01:40,06 --> 00:01:42,03
and seen this Locked button,

38
00:01:42,03 --> 00:01:43,09
you might be wondering what it means.

39
00:01:43,09 --> 00:01:45,07
It actually means nothing

40
00:01:45,07 --> 00:01:48,00
unless the sheet is protected,

41
00:01:48,00 --> 00:01:50,08
so I'm going to unlock everything for now.

42
00:01:50,08 --> 00:01:54,08
I'll click OK, and now I'm going to decide

43
00:01:54,08 --> 00:01:57,05
what I don't want people to change.

44
00:01:57,05 --> 00:02:00,07
I don't want anybody to be able to edit the Email field,

45
00:02:00,07 --> 00:02:05,00
so I'm going to lock down all of the cells in this column.

46
00:02:05,00 --> 00:02:10,03
So I'll right click and choose Format Cells...

47
00:02:10,03 --> 00:02:11,07
In the Protection tab,

48
00:02:11,07 --> 00:02:14,09
this time I'll place a check mark next to Locked.

49
00:02:14,09 --> 00:02:16,06
I'll click OK,

50
00:02:16,06 --> 00:02:19,07
and now this column will be locked from editing

51
00:02:19,07 --> 00:02:22,04
once we protect the sheet.

52
00:02:22,04 --> 00:02:24,00
Something else that I might want to do

53
00:02:24,00 --> 00:02:26,05
is protect this Home Phone column.

54
00:02:26,05 --> 00:02:28,03
I don't want anybody to be able to see

55
00:02:28,03 --> 00:02:29,06
that this column exists,

56
00:02:29,06 --> 00:02:32,05
because it's the home phone numbers of my employees.

57
00:02:32,05 --> 00:02:34,04
This could also be a salary field

58
00:02:34,04 --> 00:02:37,08
or a credit card field or something else,

59
00:02:37,08 --> 00:02:39,09
so I'm going to select the column,

60
00:02:39,09 --> 00:02:43,08
right click, and Hide the entire column.

61
00:02:43,08 --> 00:02:47,04
With those two actions done, now we'll protect the sheet.

62
00:02:47,04 --> 00:02:50,01
I'll click Protect Sheet this time,

63
00:02:50,01 --> 00:02:51,05
I'll put in a password,

64
00:02:51,05 --> 00:02:53,03
(keyboard clacking)

65
00:02:53,03 --> 00:02:54,06
and underneath that,

66
00:02:54,06 --> 00:02:56,09
I have to decide what people can do

67
00:02:56,09 --> 00:02:59,02
if they have that password.

68
00:02:59,02 --> 00:03:02,00
You can scroll through this list and check

69
00:03:02,00 --> 00:03:04,07
or uncheck what people need to do.

70
00:03:04,07 --> 00:03:07,09
I'll click OK, put the password in again,

71
00:03:07,09 --> 00:03:10,05
(keyboard clacking)

72
00:03:10,05 --> 00:03:15,00
click OK again, and now my sheet is protected.

73
00:03:15,00 --> 00:03:17,06
If somebody tries to change this,

74
00:03:17,06 --> 00:03:20,04
they're going to get a popup that says it's protected.

75
00:03:20,04 --> 00:03:22,05
To make the change unprotect it,

76
00:03:22,05 --> 00:03:24,00
and you'll need that password.

77
00:03:24,00 --> 00:03:26,01
I'll click OK.

78
00:03:26,01 --> 00:03:28,08
Now, a user will also know that there's a hidden column.

79
00:03:28,08 --> 00:03:31,02
For example, it's very easy to tell here

80
00:03:31,02 --> 00:03:33,07
that column E is missing and therefore hidden.

81
00:03:33,07 --> 00:03:37,04
However, you can't unhide it without the password.

82
00:03:37,04 --> 00:03:40,09
To unprotect it, click on the Review tab again,

83
00:03:40,09 --> 00:03:45,03
click Unprotect Sheet, and put the password in.

84
00:03:45,03 --> 00:03:47,00
(keyboard clacking)