Restrict add rows and columns

[Sasikiran]

Dear,

I have a format done on excel and I need to restrict the users to insert
columns or rows in the excel sheet.

Please suggest.

Thanks

 

[Dan]

Look at the 'protect sheet' options. In Excel 2007, it is located on the
'Review' ribbon, <Changes> section You can restrict users from almost
anything by defining what they can and cannot do. You then save the workbook
with a password. If the user opens the workbook without the password, Excel
enforces the constraints you've placed.

Hope this helps. Cheers!

--Dan

 

[Shane Devenshire]

Hi,

Are you restricting them "from" inserting columns and rows" or allowing the
to insert columns and rows?

Let's assume the first.

1. Select all the cells where you want the user to be able to work.
2. Choose Format, Cells, Protection tab, and uncheck Locked. OK
3. Choose Tools, Protection, Protect Sheet and in the dialog box check
anything your want to allow them to do. Note, by default they will not be
able to insert or delete columns and rows.

 

[Shane Devenshire]

Hi,

Protecting the workbook has nothing to do with sheet protection. If the
user knows the password to open the workbook, it won't affect the sheet
protection. If the user tries to open a password protected workbook they
won't even be able to see it if they don't enter a password.

You can add password protection to the sheet when you choose Tools,
Protection, Protect Sheet.