Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protect cells

Password protect cells

ResolvedVersion 2003

Wed 8 Oct 2008, 15:29 Delegate James said...

James has attended:
Excel Advanced course
Outlook Advanced course

Password protect cells

how protect cell content

Fri 10 Oct 2008, 15:19 Trainer Simon said...

RE: password protect cells

Hi James,

Thank you for your question.

Go to Tools and Protection and choose the option Protect sheet. Create a password and then confirm the new password. Once you click OK the whole sheet is protected from editing or deletion. All the user can do is just view the data.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Password protect cells

Password protect cells

RE: password protect cells

Excel articles

Excel tip:

Quickly insert a function