blocking cells

  • Thread starter confused of nottingham
  • Start date
C

confused of nottingham

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
 
I

IT05

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!
 
M

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
 
Top