Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |