حماية ورقة العمل في الاكسيل

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00I said hello to you again in a new video

00:03We will learn together how to protect a worksheet in Excel.

00:07First, what is the worksheet?

00:10The worksheet is the sheet we work on.

00:13We find it under one, two or three sheets.

00:19Okay, this way we are clean

00:21We have something called a worksheet, which contains our tables, calculations, and everything else.

00:26For this paper, we will start protecting it so that no one can enter it.

00:31It comes out in the middle that we entered so that no one can make any changes to the data.

00:38We can protect her.

00:40How do I protect myself? I have more than one way.

00:42The first method is to stop on the worksheet itself. For example, I stopped here on one sheet.

00:47So click on it

00:49And I started telling him to protect the paper

00:52Here he tells me what are the things that you need to protect?

00:58Ok, I allow all users of this worksheet to do the following:

01:02It is a marker for two things, which are defining the temporary cell and defining the non-temporary cell.

01:08Can I choose other things?

01:10Okay

01:12I choose everything I want

01:15As I like

01:17And give it a password, for example, from one of four, come one, two, three, four.

01:23Okay, he'll tell me to put it in again, one, two, three, four.

01:27Okay

01:29Come on, let's try to enter some data here.

01:31This tells me that the cell or chart you are trying to change is located on a protected sheet.

01:37To make a change with me, you must unprotect the sheet and you may be asked to enter the flexibility password.

01:43Okay, what if I want to remove this password and that's it, my trouble is over and I will not be able to deal with you again?

01:51Stay the same way Clicky Min

01:53But the other thing is that instead of protecting the worksheet, we will find that the worksheet has been unprotected.

01:59I will enter the password one two three four OK

02:05So, if you want us to enter any words, it will be done.

02:09Okay, this is very nice. This is a way. There are other ways that we can learn about together.

02:15If I wanted to protect my worksheet, I would go and tell him from here, so he can forget about it.

02:22paper protection

02:25I find the same things. I can remove what I don't want.

02:30Get out of here

02:32And also give him the password one two three four and I also tell him OK

02:37Enter password again

02:41Exactly, and the same thing happens if I try to enter any data here, the message will appear.

02:47Ok, I wanted to remove this protection. I told him, “If you forget me, what should I do?”

02:52Do what you want with this protection or cancel the paper protection

02:57Enter another password: one, two, three, four.

03:02So I have cancelled the protection

03:04Either I do it from below or I do it from the main ribbon tab when you forget it

03:09I told him to protect a sheet or unprotect a sheet from the same place.

03:14We would have known this information. Come on, try it.

03:17Translated by Nancy Qanqar

Category

Transcript

Recommended