How do you set an Excel File to read only?

How do you set an Excel File to 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 I enable edit mode in Excel for Mac?

Enable or disable Edit mode Click File > Options > Advanced. , 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.

How do I turn off read-only on my Mac?

Clear the read-only status of a workbook

  1. Open the Finder and select the workbook you no longer want to be read-only.
  2. On the Action pop-up menu. , click Get Info.
  3. On the General pane, clear the Locked check box.

How do I restrict editing in Excel?

To restrict editing to a sheet in Excel, use these steps:

  1. Open the Excel document.
  2. Click on File.
  3. Click on Info.
  4. On the right side, click the Protect Workbook menu.
  5. Select the Protect current sheet option.
  6. (Optional) Set a password to unlock the sheet.
  7. Check the Protect worksheet and contents of locked cells option.

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 I change a read only file on a Mac?

Word for Mac – read Only

  1. Go to the folder where the documents are stored.
  2. Select the file > Options > Get info.
  3. Clear Locked.
  4. Check if you have Read & Write permission with your account. If your current account only has Read only permission, please click the Lock icon to edit it.