Protection

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

We have several spreadsheets that feed into a report. Is there any way to
protect the sheets to allow data entry but not allow to insert extra lines?
 
Sandy
Unlock those cells into which you want to allow data entry, then protect
the sheet. The user can then enter data into those cells and not be able to
insert rows and columns. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting CELLS 2
Can I protect data in a cell, but allow comments to be entered. 6
Cell Protection Query 15
Indenting Disabled when Sheet is Protected 1
password protect allowances 1
Can't use protection options 1
Sorting while protected - this question may not have been covered. 1
copy cells but lock editing 5

Back
Top