Lock Spreadsheet Warranty For Free

1) Go to REVIEW tab and click on "Protect Sheet" option. 2) Excel opens the Protect Sheet dialog box. By default, Excel selects the Protect Worksheet and Contents of Locked Cells check box.

Protect a sheet Select Review > Manage Protection. To turn on protection, in the Manage Protection task pane, select Protect sheet. ... By default, the entire sheet is locked and protected. ... Optionally, to require a password to edit a range, select Range password, enter and confirm the password, and then select Save.

To protect the workbook, perform the following steps: On the Review tab, in the Changes group, click the Protect Workbook button. Under Protect workbook for, select one of the two options, or both: Check the Structure box to protect the structure of a workbook.

Protect the workbook structure Click Review > Protect Workbook. Note: The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. ... Enter a password in the Password box. Important: ... Retype the password and click OK.

Right-click on the selected cells and choose "Format Cells" from the menu. In the Format Cells dialog box, select the "Protection" tab. Check the box next to "Locked" to lock the selected cells. Click OK to save your changes.

Applying a password to secure an Excel workbook Open the Excel file you wish to secure. Choose Protect Workbook from the Review tab. Select Structure in the Protect Structure and Windows dialog box. Enter a password to secure the workbook. Prevent users from making changes to the structure. ... Click OK. ... Close the file.

Protect an Excel file Select File > Info. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.

Locking the workbook structure prevents other users from adding, moving, deleting, hiding, and renaming worksheets.