How do I prevent a user from entering data in a cell?

  • Thread starter Thread starter jaydub100
  • Start date Start date
J

jaydub100

I am trying to lock down a contiguous group of cells so that the user cannot
change the data or formula. How do I do that?
 
--Select the whole sheet, right click>Format cells>Protection (last tab), and
uncheck locked.
--Now select your range of cells to be locked Right click>Format cells>
Protection>check the locked box
--Now protect your worksheet. Users will be able to edit and change
information
everywhere other than the last selected range

If this post helps click Yes
 
You must log in or register to reply here.

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

How do you lock a cell with data but still allow new data entry? 1
Data Validation - Prevent delete 2
selecting non-contiguous cells 1
Excel - prevent someone from clicking into certain cells 1
How to merge 2 + contiguous cells without lossing data? 2
Data Validation - Preventing Delete from Delete Key 2
Data Validation on Locked Cell 2
Lock out data entry in a cell 1

Back
Top