blocking cells
 

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

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

1. Select all cells in the entire sheet
2. Go to FORMAT CELLS PROTECTION. Uncheck the LOCKED box
3. Select the cells you want to lock.
4. Go to FORMAT CELLS PROTECTION. Check the LOCKED box
5. TOOLS PROTECTION PROTECT SHEET (Password is optional)


Mangesh




"confused of nottingham" <confused of
wrote in message ...
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