how do I lock certain cells from getting edited

S

sahishnu

How do I lock certain cells from getting edited accidentally, while I work on
other cells in the same sheet
 
M

Mike

By default all cells in a worksheet are locked but this only becomes
effective if the worksheets is prorected. So, unlock cells you want to change
by right click - format - protection and remove the check mark from locked.
Protect the sheet using Tools - Protection - protect sheet and your done.

Mike
 

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

Cell data entering slow! 0
Is it possible to edit colours already saved as part of a custom theme? 0
Place picture in Excel cell 0
How to lock cell 4
Sub projects added as read only in Master file which are saved on sharepoint 1
VBA word change keys 0
Format column widths from one table to a separate table on same page 1
Get rid of Microsoft AutoUpdate 0

Top