lock cells unlock cells

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lock cells, unlock cells, deny changes

Lock cells, unlock cells, deny changes

resolvedResolved · Low Priority · Version 2016

judy has attended:
Excel Intermediate course

Lock cells, unlock cells, deny changes

Please could you remind me on how to lock cells within a worksheet so that other users cannot edit certain cells but can type into other cells. thanks

RE: lock cells, unlock cells, deny changes

Hi Judy,

There are two parts to this.
First you mark the cells that you want to be changeable when you protect then sheet.
Second you protect the sheet.

To mark the cells:
Select the cells that you want to be editable
Go to format cells and go to the right most tab, headed Protection and untick the check box that says Locked

To protect the sheet:
Right click on the sheet name and choose Protect Sheet from the menu. You can then choose to add a password if required. Once you have clicked OK the sheet will be locked and only the cells that you have unlocked can be changed.

To unprotect the sheet right click on the tab and choose unprotect.

I hope that helps.

Tue 24 Dec 2019: Automatically marked as resolved.


Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.

Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.

To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips

Server loaded in 0.07 secs.