Prev: change color font after updated
Next: drop down list
From: anu khan anu on 24 May 2010 07:24
plz do repl me soon
From: Roger Govier on 24 May 2010 07:36
Hi

First select all of the cells in the
Sheet>Format>Cells>Protection>remove the check mark form Locked.
Next select the single cell you want to be
locked>Format>Cells>protection>check Locked.
Tools>Protection>Protect Sheet (optionally provide a password - remember
to write it down somewhere of you do)
--
Regards
Roger Govier

anu khan wrote:
> plz do repl me soon
From: trip_to_tokyo on 24 May 2010 07:37
EXCEL 2007

This assumes that you wish to protect cells D 83 to D 85.

If you wish to protect just one cell replace D 83 to D 85 (below) with the
cell number you wish to protect.

Take the following actions assuming that the range that you wish to, "lock"
is D 83 to D 85.

1. Go into you Worksheet and click on cell to the left of column A and above
the number 1.

This should highlight the whole Worksheet.

2. Ctrl + 1 (at the same time) / Custom Lists pane should launch (sometimes
this window has a different name because there is a bug in the software here)
/ go to the Protection tab / remove the tick (check) from the Locked field
and hit OK.

3. Now go back to your Worksheet and highlight cells D83 to D 85 only / Ctrl
+ 1 again / Custom Lists should launch / go to Protection tab again and place
a tick (check) in the Locked field / OK.

4. Home tab / Cells group / Format / Protect Sheet / Protect Sheet window
should launch / put a password of your choice in / hit OK / put password in
again / OK.

5. Now to test that it has worked go back to cells D 83 to D 85.

If you try to enter info into any of those 3 cells you will not be able to
but you will be able to see the formulas there.

6. You should be able to enter data into all other cells in the Worksheet.

If my comments have helped please hit Yes.

Thanks.

"anu khan" wrote:

> plz do repl me soon
 | 
Pages: 1
Prev: change color font after updated
Next: drop down list