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 nottingham@discussions.microsoft.com>
wrote in message news:4C0D28D7-4053-43F0-8DD3-EE7BE077F8D4@microsoft.com...
> 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 nottingham@discussions.microsoft.com>
wrote in message news:4C0D28D7-4053-43F0-8DD3-EE7BE077F8D4@microsoft.com...
> 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 nottingham@discussions.microsoft.com>
wrote in message news:4C0D28D7-4053-43F0-8DD3-EE7BE077F8D4@microsoft.com...
> 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 nottingham@discussions.microsoft.com>
wrote in message news:4C0D28D7-4053-43F0-8DD3-EE7BE077F8D4@microsoft.com...
> 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
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 nottingham@discussions.microsoft.com>
wrote in message news:4C0D28D7-4053-43F0-8DD3-EE7BE077F8D4@microsoft.com...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks