How to lock certain cells in excel. In the format cells dialog click.

Excel Locking Columns Rows Using Freeze Panes Keep Header Row

Select the cells you want to unlock.

How to unlock cells in excel 2007. Type a password if you want one and then click ok. At first we will need to select the cells we want to lock. Click to select the locked check box and then click ok.

If the worksheet is protected click the unprotect sheet button in the changes group on. Right click on then select format cells from the popup menu. Click the protect sheet button to unprotect sheet when a worksheet is protected.

To unlock cells in a worksheet follow these steps. Press on the format cells option. These are the cells you want to allow users to edit when.

After selecting the cells press on the right click button of the mouse. Press ctrl 1 to open the format cells dialog box and. After the format cells window open press on the protection option and click on the locked option.

The help function taught me how to lock the cells we want to lock ones that have formulas in them. Click review unprotect sheet then type password in the unprotect sheet dialog and click ok. Next select the cell s that you wish to protect.

Then select the cells you want to unlock and right click to select format cells in. Uncheck the locked checkbox. I believe it s an older version of excel probably excel 2007.

Image 6 in excel 2007 or later click the review tab and click protect sheet. Return to the format cells dialog box and then click the protection tab. Select the whole worksheet by.

Lock unlock cells in protected worksheet in format cells feature 1. On the review tab click unprotect sheet in the changes group. Click on the ok button.

When the format cells window appears select the protection tab. I have been tasked by my pastor to learn how to lock some cells in the excel spreadsheet the church uses to tabulate the week s donations. Lock only specific cells and ranges in a protected worksheet.

If prompted enter the password to unprotect the worksheet.