Block Out Spreadsheet Attestation 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 the Restrict permission to this workbook check box, and then select More Options.

Click on the cell(s) you wish to lock. To open the Format Cells pop-up window, navigate to the "Home" tab in your Excel spreadsheet. To do so, select "Format" from the right-hand menu. From the drop-down menu, select "Lock Cell."

Given below are the steps to protect your sheet. 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. Option. ... Optionally, enter a password in the Password to unprotect sheet box and click OK.

Click the Home tab and in the Cells group, click Format > Hide and Unhide and pick either Hide Rows or Hide Columns.

Protect Workbook (which is not full proof) option will give you an additional layer of security that no one is able to unhide your sheet unless they unprotect the workbook (and know your password). But protecting workbook also locks out adding, moving, deleting, hiding worksheets and renaming worksheets.

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

Hide the columns: select them, right-click and pick the Hide option from the pop-up menu. Now navigate to the Review tab and click on the Protect Sheet icon. Make sure the checkboxes Select locked cells and Select unlocked cells are ticked. Then enter and reenter the password.

Click Review > Protect Workbook. Enter the password and then click OK.