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:
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:
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.)
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:
- In case you want to use the disabled feature, proceed as follows: Right-click on the protected Sheet name -> UnProtect Sheet:
- The Unprotect Sheet dialog box appears -> enter the password created in the previous step to protect the worksheet -> click OK:
- After Unprotect sheet is finished, go back to the worksheet and check the Insert and Delete features:
The above is a detailed guide on how to protect spreadsheets in Excel 2013.
Good luck!
You should read it
- How to create a password protection for Excel sheets
- 5 source to get macro to automate Excel spreadsheets
- How to lock Excel file, set password, pass for Excel file
- How to open multiple spreadsheets side by side in Excel 2013
- Tips with spreadsheets (sheet) in Excel
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- How to print Excel, print Excel spreadsheets fast, standard
- Steps to lock columns in Excel
May be interested
- Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excellet's refer to tipsmake.com's article on how to format pages and print spreadsheets in excel 2016!
- How to rename, copy and move spreadsheets in Excelinstructions 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
- Lock a range of data on Excel spreadsheetsafter you have finished processing data in excel spreadsheets, sometimes for some reason you do not want others to edit the data of a range of data in excel spreadsheets.
- How to print multiple sheets at once in Excel spreadsheetsafter you finish drafting an excel document of two or more sheets and want to print them on paper, you have trouble knowing how to print multiple sheets at once. tipsmake.com has written this tutorial to show you how to print multiple sheets at once in excel spreadsheets.
- How to set Excel password to secure data filesetting 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.
- How to fix filter errors in Excel spreadsheetsguide you how to best fix filter errors in excel, this is the error that users often encounter when using excel spreadsheets
- Excel 2016 - Lesson 3: How to create new and open existing spreadsheetshow to create excel files on a computer is not difficult. below are detailed instructions on how to create excel files and open spreadsheets for beginners.
- Instructions for adding more Sheets and spreadsheets in Excelin excel, adding sheets and spreadsheets expands your data management capabilities. here are simple, effective instructions to help users get up and running quickly.
- Excel 2016 - Lesson 11: Check spelling in Excel spreadsheetslet's refer to the instructions for checking spelling on excel 2016 spreadsheets in this article with tipsmake.com!
- Instructions for searching and replacing in Excel tableswith excel spreadsheets containing hundreds and thousands of data, search and replace by formula will help us save a lot of time, increase work efficiency compared to manual methods.