How to protect spreadsheets in Excel

The following article provides detailed instructions for you to protect spreadsheets in Excel.

Protecting spreadsheets is an essential need of many users, thanks to this feature who makes spreadsheets can secure their data. To protect a spreadsheet, follow these steps:

Step 1: Right-click the name of the worksheet to be protected -> Protect Sheet:

How to protect spreadsheets in Excel Picture 1

Step 2: The Protect Sheet dialog box appears:

+ Password to unprotect sheet: Enter the password to protect the spreadsheet.

+ Allow all users of this worksheet to: Select the components to protect. For example, here select Insert Rows, Insert Column (users cannot insert rows and columns for the worksheet) -> OK:

How to protect spreadsheets in Excel Picture 2

Step 3: After clicking OK, the Confirm Password dialog box appears asking you to retype the password -> OK. (If you enter the password incorrectly, Excel requires you to enter it again.)

How to protect spreadsheets in Excel Picture 3

Step 4: After clicking OK, go back to the spreadsheet to check whether it is protected or not. Right-click on any line as shown in the figure , the Insert and Delete features are disabled -> the worksheet of the table is protected:

How to protect spreadsheets in Excel Picture 4

- In case you want to use the disabled feature, proceed as follows: Right-click on the protected Sheet name -> UnProtect Sheet:

How to protect spreadsheets in Excel Picture 5

- The Unprotect Sheet dialog box appears -> enter the password created in the previous step to protect the worksheet -> click OK:

How to protect spreadsheets in Excel Picture 6

- After Unprotect sheet is finished, go back to the worksheet and check the Insert and Delete features:

How to protect spreadsheets in Excel Picture 7

The above is a detailed guide on how to protect spreadsheets in Excel 2013.

Good luck!

5 ★ | 1 Vote

May be interested

  • How to insert and delete worksheets in ExcelPhoto of How to insert and delete worksheets in Excel
    instructions on how to insert and delete worksheets in excel. 1. insert a sheet (sheet) in excel. step 1: right-click on any sheet (or you can choose a new sheet location) - insert: step 2: the insert dialog box appears - click worksh
  • How to choose images as a background for a spreadsheet in ExcelPhoto of How to choose images as a background for a spreadsheet in Excel
    detailed instructions to you how to choose images to make up the worksheet in excel. to create wallpaper you follow these steps: 1. create a wallpaper for spreadsheets from images available on the computer. step 1: go to pagelayout - background: step 2: insert p dialog box
  • How to change the SheetTab color and hide the worksheet in ExcelPhoto of How to change the SheetTab color and hide the worksheet in Excel
    instructions on how to change the color sheettab and hide the worksheet display in excel. sheettab is where the names of the sheets are displayed so you need to color them to distinguish them better. 1. how to change the color of sheettab in excel. step 1: right-click the name of the sheet to change color - tab color -
  • How to rename, copy and move spreadsheets in ExcelPhoto of How to rename, copy and move spreadsheets in Excel
    instructions on how to rename, copy and move spreadsheets in excel. 1. how to change the name of the worksheet (sheet) in excel - method 1: + double-click the worksheet name - when the selected worksheet name is entered, enter the new name of the worksheet: + after entering the name
  • Overview of the interface in Excel 2013, 2016Photo of Overview of the interface in Excel 2013, 2016
    overview of the interface in excel 2013, 2016. the following article helps you understand the overview of the interface in excel 2013, 2016. when you open the excel interface, work as shown.
  • How to convert CAD files to Word the fastest and most standard wayPhoto of How to convert CAD files to Word the fastest and most standard way
    you are in need of converting drawings in cad files to word for printing or presentations but do not know how to transfer? how to quickly convert cad files to word, keep the best image quality, fonts, then you need to use betterwmf software - copy the image