Get With Excel 2007 Microsoft Has Modified Its Paradigm For Protecting The Excel User From

Follow these steps to lock cells in a worksheet: Select the cells you want to lock. On the Home tab, in the Alignment group, select the small arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK to close the popup.

You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells dialog box, select the Protection tab and uncheck the Locked box and then select OK. This unlocks all the cells on the worksheet when you protect the worksheet.

Require a password to open or modify a workbook Open the sheet or workbook that you want to protect. On the Review tab, click Protect Sheet or Protect Workbook. In the Password box, type a password, and in the Verify box, type the password again. Choose any other protection options you want and click OK. Click Save.

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. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box and select OK.

Step 1− Select the cell in the worksheet from which you need to remove the data value restriction. Step 2− Click Data Validation under Data > Data Tools. Step 3− Click Clear All under the Settings Tab of the dialog box as shown below. If you want to remove the similar data restriction from all other cells.

Use the "Allow edit ranges" features: Unprotect the entire Sheet> Select the ranges of cells you want to unlock> Click on Review> Select "Allow edit ranges"> Click on protect button and enable protection of sheet> Click on Ok> Click on Apply> now you can edit the selected ranges.

I want to change my Protected View settings Click File > Options. Click Trust Center > Trust Center Settings > Protected View. Make selections that you want.

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.