 Hello viewers, welcome to my channel. You will learn how to protect worksheets and Google sheets in this video. Here I have two worksheets which are named Data 1 and Data 2. I'm going to protect this worksheet for that right click on the tab and select the Protect Sheet option. In that, you have two options to protect. One range and another one is sheet. Below that you can find a box with the drop-down option in that drop-down you will find all the worksheets. Select the worksheet which you are going to protect. Below that you can find a checkbox that checkbox will help us to accept certain cells and ranges from the protected sheet. Now by clicking on the set permissions you can enable the sheet protection in which you will find two options one is to show a warning when editing this range and another one is to restrict who can edit this range. Now I'm selecting restrict who can edit this range after below that you can find a box with the drop-down option in which you will find only you and the custom. Now I'm selecting the only you option. This option will protect the sheet and only you can edit and protect it from others and making any changes in the sheet. You can also edit the protection permission by clicking this can edit. Now click on change permissions. You can change permission from only you to custom. Just enter the email ID which you are going to share the permission. Click on done. Now you have changed the permission from only you to the mail ID you have entered. Click on done. Now I show you how to set protection except for certain cell or range. By clicking the checkbox except for certain you will find the box in below and in the you can enter cell or range. Click OK. By clicking add another range you can also make multiple exceptions for cells and ranges. Click on done. Now you have exceptions multiple cells and ranges. Another kind of option to protect the sheet is by selecting show a warning when editing this range. Click done. Now if the sheet will show a warning message while editing the sheet. If you want to avoid this warning message for a while you can click on the check box here and click OK that will not show you the warning message for five minutes. You can also remove this protection by clicking on it and pressing the delete icon and selecting remove. That's it the protection has now been removed. You have learned how to protect worksheets ranges and cells and google sheets. Kindly check out my previous video how to duplicate hide unhide color and copy worksheets and google sheets. Thank you for watching this video. If this video is useful consider to subscribe my channel and don't forgot to like and share the video. Thank you.