Try this:

highlight the cells you don't want to block. Then select
Format/Cells/Protection/Remove the Unlock Check.

Next step: goto: Tools/ Protection/Protect Sheet/Check the tree boxes/ and
assign Password. Depending on your application you may not want to check all
three boxes.

Summary: this protects a spreasheet from changes with the exception of the
cells that are Unlocked!


"confused of nottingham" wrote:

hi can anyone tell how to block cells and colums

basically i have a spreadsheet and i need to protect the formula and
contents of above 20 cells in 2/3 colums and don't seem to find a way to be
able to do it.

i'd be really grateful for anyhelp

cheers

Paul