Block Out Spreadsheet Article For Free

Select File > Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select Restrict permission to this workbook, and then assign the access levels that you want for each user.

Protect, hide, and edit sheetsOpen a spreadsheet in Google Sheets.Click Data. Protected sheets and ranges.Click Add a sheet or range or click an existing protection to edit it.To protect a range, click Range.Click Set permissions or Change permissions.Choose how you want to limit editing:Click Save or Done.

In your sheet of interest, go to Format -> Sheet -> Hide and hide your sheet. Go to Tools -> Protection -> Protect Workbook, make sure Structure is selected, and enter your password of choice.

Enable worksheet protectionIn your Excel file, select the worksheet tab that you want to protect.Select the cells that others can edit.Right-click anywhere in the sheet and select Format Cells (or use Ctrl+1, or Command+1 on the Mac), and then go to the Protection tab and clear Locked.

To protect a sheet, select a tab in your Excel workbook, click on the Review tab and choose the Protect Sheet menu option. This option allows for very specific protections of your spreadsheet. By default, the options will almost totally lock down the spreadsheet. Let's add a password so that the sheet is protected.

Protect an Excel fileSelect 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.

Open the workbook that you want to protect. On the Review tab, under Protection, click Passwords. In the File Passwords dialog box, select the Read-only recommended check box, and click OK. Close the workbook.