Restrict editing of some cells on a document

geordie_ben

Board Regular
Joined
Jul 27, 2009
Messages
122
I have a spreadsheet I need customers to amend.

I need them to be able to:
  • Insert rows
  • Not amend any cells contents in Column A
  • Be able to edit the cell contents of Columns B-E

I've tried playing around with protecting the sheet, and marking certain ranges as Locked, but I can't get it to lock Column A, but allow B-E to be editable

Any help please?
 
Last edited:

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Bengo

Board Regular
Joined
Apr 14, 2010
Messages
202
I have a spreadsheet I need customers to amend.

I need them to be able to:
  • Insert rows
  • Not amend any cells contents in Column A
  • Be able to edit the cell contents of Columns B-E

I've tried playing around with protecting the sheet, and marking certain ranges as Locked, but I can't get it to lock Column A, but allow B-E to be editable

Any help please?

If you highlight all cells in columns B to E, right click, and un-tick locked on the protection tab, that will allow you to edit these when the sheet is protected. Then when protecting the sheet, tick insert rows and delete rows to allow them to add rows. The issue you will have is they still won't be able to add anything into column A of newly inserted rows, although they will be able to in B:E of the new row
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,655
Messages
5,524,131
Members
409,561
Latest member
ay123

This Week's Hot Topics

Top