HomeApplicationOffice information

How to create a password protection for Excel sheets

In addition to creating passwords for Excel files, preventing file opening, we can also create passwords for sheets in the data sheet. When setting a password, the sheets will be locked and prevent others from editing the content illegally. Editing on the sheet will not work, but the content in each sheet is still trackable. Readers can track how to lock sheet in Excel in the article below.

  1. MS Excel - Lesson 4: Working with lines, columns, sheets
  2. How to temporarily hide rows and columns in Excel 2013
  3. Change color between different lines in Microsoft Excel

How to create a password for a sheet in Excel

Step 1:

We open the Exce file and the data sheet wants to create a secure password. In that sheet, click the Review tab on the Ribbon and then select the Protect Sheet .

How to create a password protection for Excel sheets Picture 1

Step 2:

A small dialog box appears. At this point, the user enters the password that you want to place the sheet in the Password to unprotect sheet . Then click OK to save.

How to create a password protection for Excel sheets Picture 2

Step 3:

Soon the Confirm Password dialog box appears. We need to enter the correct password created in Reenter password to proceed frame. If you forget or enter the wrong password, it cannot be restored.

Finally click OK to verify.

How to create a password protection for Excel sheets Picture 3

Thus, we have completed the operation of creating security passwords for sheets in Excel, locking operations to edit the content in the sheet sheet. When the other person clicks the mouse to perform the editing of the content in the sheet, a bulletin board appears as shown below.

How to create a password protection for Excel sheets Picture 4

Step 4:

To remove the security password created for the sheet in Excel, we also click the Review tab and click on the Unprotect Sheet entry.

How to create a password protection for Excel sheets Picture 5

Step 5:

Enter the correct password previously set in the Password box, then click OK to confirm. Thus users can remove the password for the sheet in Excel.

How to create a password protection for Excel sheets Picture 6

By setting the password for the sheet in Excel, you can restrict the manipulation of content by notification, as soon as you click on that sheet in Excel. If you want the content on the sheet to be trackable, but don't want to be edited illegally, we can create an Excel sheet password according to the above article.

Video tutorial to create password for sheet on Excel

I wish you all success!

5 ★ | 1 Vote

You should read it

May be interested

  • 5 reasons you should give up Excel and start using Google Sheets5 reasons you should give up Excel and start using Google Sheets
    google sheets is a spreadsheet web application that works as part of the google docs toolkit. google sheets was released in 2006, nearly two decades after the first release of microsoft excel.
  • How to set Excel password to secure data fileHow to set Excel password to secure data file
    setting up excel password has many ways, from simple to use excel's built-in password feature to use vba. below tipsmake.com will show you the most basic ways to protect your excel file.
  • MS Excel - Lesson 4: Working with lines, columns, sheetsMS Excel - Lesson 4: Working with lines, columns, sheets
    in addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
  • How to create graphs, charts in Google SheetsHow to create graphs, charts in Google Sheets
    google sheets also features a graphical representation, showing the data that are included so that users can change the chart.
  • How to compare data on 2 different sheets in Excel fileHow to compare data on 2 different sheets in Excel file
    to compare data on 2 different sheets but in the same excel file, we have many different methods such as using vlookup or using the countif function and combining with conditional formating to create different comparison effects. or no difference in data in two different sheets.
  • How to convert Excel file to Google SheetsHow to convert Excel file to Google Sheets
    to convert excel file to google sheets in the same format, users can download excel file to google drive or import excel file into existing google sheets file.
  • Use images instead of passwords - Should I use them?Use images instead of passwords - Should I use them?
    the most common way to protect computers, laptops and a variety of other devices for windows users is now password. however, windows 8 has come up with an extremely interesting new feature: use an image to replace the password.
  • Create a table of contents for a list of worksheets in ExcelCreate a table of contents for a list of worksheets in Excel
    your excel spreadsheet has many sheets, you want to manage them in the most scientific way so they can quickly open when needed. to manage the sheets quickly and easily, you need to create a table of contents of the list of sheets in the excel file.
  • How to print multiple sheets in ExcelHow to print multiple sheets in Excel
    print sheets in excel file can choose to print multiple sheets or print all sheets with a simple and very easy way.
  • Create Hyperlink in ExcelCreate Hyperlink in Excel
    create hyperlinks in excel - the following article guides you to create hyperlinks to websites, to other sheets in the same excel file, links to newly created excel files and links to email addresses.

Office information