PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO PROTECT AND UNPROTECT SHEET WITH PASSWORD OR WITHOUT PASSWORD IN EXCEL?

INTRODUCTION

In Excel Review Tab, we have many different functions like spell check, researching , thesaurus and translation function. These were already discussed in the previous post HOW TO USE RESEARCH, THESAURUS AND TRANSLATION IN EXCEL?

In the same TAB few more functions are also present. The comments and protecting the worksheet against any kind of change in data.This article deals with the protection of the sheet.

 

BUTTON LOCATION FOR PROTECT AND UNPROTECT SHEET IN EXCEL

The OPTIONS for PROTECTING AND UNPROTECTING sheets are found under the REVIEW tab in CHANGES subsection as shown in the picture.

protect unprotect sheet excel
BUTTON LOCATION OF PROTECT AND UNPROTECT SHEET

STEPS TO PROTECT A SHEET IN EXCEL

Sheet can be protected against any kind of changes in the worksheet. Let us discuss the different available options.

protect worksheet in excel
DIFFERENT OPTIONS AVAILABLE FOR PROTECTING A WORKSHEET

STEPS TO PROTECT IN EXCEL-PROTECT SHEET

It gives the option of providing the access to specific function and protecting it with the help of a password.

The actions available can be chosen from the given list and a password canbe given to protect it.

protect worksheet in excel
DIFFERENT OPTIONS AVAILABLE FOR PROTECTING A WORKSHEET
  • STEPS:
  • click PROTECT SHEET. The following dialog box will open.
  • Choose a password.
  • Choose all the functions by clicking the checkbox, which you want to be allowed to users.
protect sheet option in excel
PROTECT WORKSHEET DIALOG BOX

STEPS TO PROTECT WORKBOOK

Protect Structure and Windows protects the structure of the workbook by avoiding the moving, deleting etc. of the sheets. Permission is restricted by the use of LIVE ID etc. which won’t be discussed here.

protecting workbook in excel
PROTECTING WORKBOOK IN EXCEL

STEPS TO SHARE WORKBOOK

If the workbook is put in a network location, Many users can work on the same workbook at the same time. This permission can be given by the use of this option.

STEPS:

  • Click Share Workbook.
  • Click Checkbox to allow users to work on the workbook.
sharing workbook excel
SHARE WORKBOOK DIALOG BOX

ADDITIONAL OPTIONS TO PROTECT CHANGES IN WORKBOOK

PROTECT AND SHARE WORKBOOK:

This option gives the option of sharing the workbook with a password and tracking option. Tracking is done of the changes made by the users.

PROTECT AND SHARE WORKBOOK EXCEL DIALOG BOX
PROTECT AND SHARE DIALOG BOX
ALLOW USERS TO EDIT RANGES:

This option allows the user to give the range where the editing can be done. Click NEW and choose the range.

ALLOW USERS TO EDIT RANGES DIALOG BOX
EDIT USERS TO EDIT RANGES DIALOG BOX
TRACK CHANGES DONE TO A WORKSHEET:

In a shared workbook, this option allows to check the changes done by the USERS.

TRACK CHANGES IN EXCEL
TRACK CHANGES DONE TO A WORKSHEET IN EXCEL

STEPS:

Select “Track changes while editing…”.

Highlight can be done as per the available choices, When, Who and Where.

OTHER WAYS TO REACH THIS ARTICLE

  • PROTECTING WORKSHEET, PASSWORD TO PROTECT WORKSHEET, HOW TO STOP EDITING IN MY WORKSHEET, SHARING IN EXCEL

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: