Limit Spreadsheet Warranty For Free

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.

Read-only Workbook Open a workbook. On the File tab, click Save As. Click Browse. Click on the Tools button and click General Options. In the Password to modify box, enter a password and click OK. ... Reenter the password and click on OK. ... Enter a file name and click Save.

Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. Right click and choose Format cells. Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect.

How to Protect Individual Worksheets by User Step 1: Open the Workbook. Open the Excel workbook that contains the worksheet you want to protect. Step 2: Select the Worksheet. ... Step 3: Click on the "Review" Tab. ... Step 4: Click on "Protect Sheet" ... Step 5: Set Permissions. ... Step 6: Click "OK"

You can protect Excel workbooks at the file level or at the worksheet level. There are three levels of password protection in Excel: password protection to open a file, password protection to change data, or password protection for changing the file's structure, such as adding, deleting, or hiding worksheets.

Protecting Individual Worksheets by User in Excel Step 1: Open the Workbook. Step 2: Select the Worksheet. Step 3: Click on the "Review" Tab. Step 4: Click on "Protect Sheet" Step 5: Set Permissions. Step 6: Click "OK"

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.