protect column & rows

[santhoshlk]

hi friends


can any onle give me the light pls


i have a sheet filled with data used by my assts. and they update them regularly.

i need to restrict/ protect the file only from inserting/ deleting rows/ columns. rest all they can do.

pls help

 

[santhoshlk]

any help????????

 

[Peter_SSs]

What version of Excel are you using?

For most recent versions, when you protect the sheet you have a list of things to allow the user to do. Could you remove the 'Locked' property from all cells and then select all the items in the list except inserting/deleting rows/columns when you protect the sheet?

 

[santhoshlk]

hi peter iam using Excel 2007.... and i got it... thanks a lot

 

[santhoshlk]

hi there...

i just tried that but it protects all columns. i just need to protect from modify/enter/delete data from a cpecic colun (say Col C)

is it possible

 

[Peter_SSs]

i need to restrict/ protect the file only from inserting/ deleting rows/ columns.

i just need to protect from modify/enter/delete data from a cpecic colun (say Col C)

Your requirements seem to have changed.
Your original request was to protect from inserting or deleting columns or rows.
Your latest request appears to be to protect from inserting or deleting data in a column.

What is it that you really want? You need to be very clear.

 

[santhoshlk]

Peter,

thanks for reply... I need to protect the whole sheet from delete/inserting rows/columns and also i need to protect some specific columns from enetring/mdoify/deleting data in to it.

so they can just read those data and they can enter datas in other columns

 

[Peter_SSs]

I need to protect the whole sheet from delete/inserting rows/columns ..

OK, we dealt with that earlier.

.. and also i need to protect some specific columns from enetring/mdoify/deleting data in to it.

so they can just read those data and they can enter datas in other columns

For this,

0. Ensure the sheet is UNprotected.

1. Select the whole sheet. One way is to click the rectangle above the row 1 label and to the left of the column A label.

2. Press Ctrl+1 to open the Format Cells dialog.

3. On the Protection tab, remove the check mark from 'Locked' & click OK.

4. Select the columns that you want to stop users from being able to edit the data in.

5. Press Ctrl+1 to open the Format Cells dialog again.

6. On the Protection tab, insert the check mark in the 'Locked' box & click OK.

7. Protect the sheet, remembering from before ..

.. select all the items in the list except inserting/deleting rows/columns when you protect the sheet

 

[santhoshlk]

thanks a lot peter