How do you set an Excel File to read only?
Save as read only
- Click the Microsoft Office Button. , and then click Save or Save As if you have previously saved the document.
- Click Tools.
- Click General Options.
- Click the Read-only recommended check box.
- Click OK.
- 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
- Open the Finder and select the workbook you no longer want to be read-only.
- On the Action pop-up menu. , click Get Info.
- 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:
- Open the Excel document.
- Click on File.
- Click on Info.
- On the right side, click the Protect Workbook menu.
- Select the Protect current sheet option.
- (Optional) Set a password to unlock the sheet.
- Check the Protect worksheet and contents of locked cells option.
How do I restrict access to an Excel spreadsheet?
- Go to File > Info > Protect Document/Workbook/Presentation > Restrict Permission by People > Restricted Access. The Permission window will open.
- 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
- Go to the folder where the documents are stored.
- Select the file > Options > Get info.
- Clear Locked.
- 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.