How To Lock Excel File For Editing?

Protect a Worksheet from Editing Click on the “Review” tab on the main Excel ribbon. Click “Protect Sheet.” Enter the password you would like to use to unlock the sheet in the future. Re-enter the password you made to confirm that you remember it and then click “OK.”

Contents

How do I make an Excel file read only?

Save as read only

  1. Click the Microsoft Office Button. , and then click Save or Save As if you have previously saved the document.
  2. Click Tools.
  3. Click General Options.
  4. Click the Read-only recommended check box.
  5. Click OK.
  6. Save the document.

How do you protect an Excel workbook but allow read only?

For a better protection, protect a sheet.

  1. Open a workbook.
  2. On the File tab, click Save As.
  3. Click Browse.
  4. Click on the Tools button and click General Options.
  5. In the Password to modify box, enter a password and click OK.
  6. Reenter the password and click on OK.
  7. Enter a file name and click Save.

How do I lock an Excel spreadsheet?

Protect an Excel file

  1. Select File > Info.
  2. Select the Protect Workbook box and choose Encrypt with Password.
  3. Enter a password in the Password box, and then select OK.
  4. Confirm the password in the Reenter Password box, and then select OK.

How do I restrict access to an Excel spreadsheet?

  1. Go to File > Info > Protect Document/Workbook/Presentation > Restrict Permission by People > Restricted Access. The Permission window will open.
  2. Make sure the Restrict Permission to this document box is selected. Enter the email addresses of individuals who can Read or Change the document. Click ok.

How do you hide and lock a sheet in Excel?

Regular Way of Hiding a Worksheet in Excel
PRO TIP: To hide multiple sheets at one go, hold the Control key and then select the sheet tabs (that you want to hide) one by one. Once selected, right-click on any one of the selected tabs and click on ‘Hide”. This will hide all the worksheets at one go.

How do I turn off editing in Excel?

Enable or disable Edit mode
, click Excel Options, and then click the Advanced category. Under Editing options, do one of the following: To enable Edit mode, select the Allow editing directly in cells check box. To disable Edit mode, clear the Allow editing directly in cells check box.

Can I hide a worksheet in Excel?

Click the tab for the first sheet. Then hold down Command while you click the tabs of the other sheets that you want to select. Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet.

How do I make an Excel file unless a password?

Read-only Workbook

  1. Click on the Tools button and click General Options.
  2. In the Password to modify box, enter a password and click OK.
  3. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don’t enter a password and check Read-only recommended.

How do you protect a sheet?

How to lock all the cells in an Excel worksheet

  1. Navigate to the Review tab.
  2. Click Protect Sheet. In the Protect Sheet window, enter a password that’s required to unprotect the sheet (optional) and any of the actions you want to allow users.
  3. Click OK to protect the sheet.

How do I lock an Excel spreadsheet online?

On the Review tab, click Protect Sheet. In the Allow all users of this worksheet to list, select the elements you want people to be able to change. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.