lock cells for input

K

Khoshravan

There was a command, protecting cells from unwated edit.
I thought it is in options or cells, but I couldn't find.
Do you where is it?
 
S

Stefi

First make sure in Cell formatting/Protection tab that cells you want to
protect are Locked and cells you want to allow to edit are unlocked. Then
Tools/Protection/Protect sheet!

Regards,
Stefi


„Khoshravan†ezt írta:
 

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

Place picture in Excel cell 0
Word macro that can call cells out of Excel for a find and replace 0
Microsoft Office Standard 2013 0
Protecting Word 2019 document 0
Disable auto-input of cell when typing a minus 0
Copy addition formula of non-consecutive horizontal cells 2
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top