+3 votes
210 views
How to add Excel 2019 protected and edit sheet

in Office by (552k points)
reopened | 210 views

1 Answer

+4 votes
Best answer

Add a sheet with restricted edition in Excel 2019

Excel 2019 is one of the most complete office applications that Microsoft has developed in order to facilitate the work and control of large amounts of data. Thinking about the security and integrity of many of this data, Excel 2019 gives us the opportunity to protect both the cells and the sheet itself from unauthorized editions. This is a security aid since a vulnerability in the contents of a workbook in Excel or a badly entered data can lead to the fact that the whole structure worked is badly done affecting our productivity and incurring time that can be used for other tasks ..

If we restrict the options of our document within Excel 2019 we can improve the security of our work by preventing other users from modifying what we have done. They are interesting options when it comes to important documents that we don't want to be changed since your information is really relevant. With these protected editing options we will prevent damage to our data and we can transfer it without problem.

image

TechnoWikis will explain how to add a new protected worksheet in Excel 2019..

To keep up, remember to subscribe to our YouTube channel! SUBSCRIBE

Add a sheet with restricted edition in Excel 2019

Step 1

By default, when we work on a new Excel 2019 workbook, the first sheet will be cataloged as “Sheet 1”, to add more sheets to that book just click on the + sign located at the bottom and more sheets will be added following the Sequence Sheet 2, Sheet 3, etc:

image

Step 2

We can right click on the available sheets to carry out tasks such as:
  • Rename the sheet
  • Remove sheet
  • Protect the blade
  • Move or copy it and more actions.

image

Step 3

For this tutorial we will focus on the action of protecting the sheet, for this we select the sheet to be edited, right click on it and select the option “Protect sheet” and the following wizard will be displayed:

image

Step 4

There we must enter the password with which the cell edition will be unlocked in the “Password to unprotect the sheet” field, we must validate that the “Protect sheet and contents of locked cells” box is active and in the other cells we can define the actions that users can carry out on the selected sheet, once defined, click on the "Accept" button to apply the changes and we will need to confirm the assigned password:

image

Step 5

Again click on "Accept." Based on the actions that we have defined, for example, to prevent the formatting, we can see that if you right-click on any cell of the protected sheet these formatting options will not be active:

image

Step 6

Similarly, if we try to make any changes we will see the following message: image
Step 7

To unprotect the locked sheet, we must right click on the protected sheet and there we select the option "Unprotect sheet":

image

Step 8

Now, in the pop-up window, we must enter the password we have set to complete the process. Click on Accept and in this way the options will be enabled again to carry out the necessary actions in the Excel 2019 sheet.

image

In this way Excel 2019 gives us the opportunity to add and protect spreadsheets in order to prevent the entry of erroneous information or changes not defined in them.


by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Oct 1, 2019 in Office by backtothefuture (552k points) | 236 views
+5 votes
1 answer
asked Nov 29, 2019 in Office by backtothefuture (552k points) | 370 views
+4 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (552k points) | 344 views
+3 votes
1 answer
asked Jun 23, 2019 in Office by backtothefuture (552k points) | 277 views
+4 votes
1 answer
asked Oct 3, 2019 in Office by backtothefuture (552k points) | 228 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users