How do i Lock certain cells to prevent typing?

S

sokevin

Hi,

I have a spreadsheet, where half of the data is from a download (whic
should be never changed manually) from a system and the other half i
entered manually.

How do i lock certain parts of the w/s so that it prevents accidenta
changing of the data.

thanks in advance

kevin :
 
N

Norman Harker

Hi Sokevin!

If you use:

Tools > Protection > Protect Sheet
Give and confirm password

The entire sheet will be protected against user entry.

So you can see that by default, when protection is implemented using
the Tools menu, all cells are locked.

To unlock cells to allow user entry you must remove the lock in the
Format > Cells > Protection dialog *before* you use Tools > Protection
Protect Sheet.
Click to expand...

In your case where it is only your downloaded data cells you want to
protect:

Select all cells [press button at junction of row and column heads]
Format > Cells > Protection
Remove check from "Locked"
OK
Select your data cells
Format > Cells > Protection
Place check in "Locked"
OK
Tools > Protection > Protect Sheet
Give and confirm password [Optional]
OK


But be aware that worksheet protection is very easily removed by
freely available password removing programs.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top