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

protecting cells

ResolvedVersion 2003

Ian has attended:
Excel Intermediate course

Protecting cells

How do you protect a single cell's info from being changed by somebody else accessing your file?

RE: protecting cells

Hello Ian

Thank you for your question and welcome to the forum.

First you would need to select your whole spreadsheet, by using Ctrl+A. Then hold down the Ctrl key and click on the cell that you want to protect - this deselects that particular cell.

Then unlock all the selected cells (Format - Cells - Protection - uncheck the Locked box.

Then apply protection (Tools - Protection - Protect Sheet).

This should apply protection only to the cell you deselected earlier, as all other cells in the spreadsheet are unlocked and therefore protection is not applied to these cells.

Kind regards
Amanda

Thu 16 Apr 2009: Automatically marked as resolved.

Excel tip:

Purchase excel

Buy MS Excel on Amazon.com

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.