blocking cells

[Guest]

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

 

[Guest]

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!

 

[Mangesh Yadav]

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