How do I make a spreadsheet restricted?
Open the file. Select File Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select the Restrict permission to this workbook check box, and then select More Options.
How do I unprotect an Excel spreadsheet without the password?
Just do any of the following: Right-click the sheet tab, and select Unprotect Sheet from the context menu. On the Review tab, in the Changes group, click Unprotect Sheet. On the Home tab, in the Cells group, click Format, and select Unprotect Sheet from the drop-down menu.
How do I make an Excel spreadsheet not editable?
Restrict Editing Click Review Protect Restrict Editing. Under Editing restrictions, select Allow only this type of editing in the document, and make sure the list says No changes (Read only). Select Yes, Start Enforcing Protection.
How do I make text block in Excel?
Click in the worksheet, and then drag to draw the text box the size that you want. To add text to a text box, click inside the text box, and then type or paste text. Notes: To format text in the text box, select the text, and then use the formatting options in the Font group on the Home tab.
How do I GREY out part of an Excel spreadsheet?
Use Conditional Formatting to Grey Out Unused Cells From here, in the Format values where this formula is true enter the formula =IF(A1=,TRUE,FALSE). Next, click on the Format button, go to the fill tab, and select the grey color. Click OK to save the option.
How do I unblock a spreadsheet?
You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.
How do I remove protection from an Excel spreadsheet?
Unprotect an Excel worksheet To unprotect a sheet, follow these steps: Go to the worksheet you want to unprotect. Go to File Info Protect Unprotect Sheet, or from the Review tab Changes Unprotect Sheet.
How do I remove access from an Excel spreadsheet?
How to Unshare an Excel File on Windows? Open Windows Explorer and go to your OneDrive folder, which should appear among other folders on the left-side menu. Right-click on the file you wish to unshare and select Give access to, then Remove access.
How do you block out in Excel?
On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then click OK to close the popup.
How do you lock a spreadsheet so it Cannot be edited?
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.
