how do I protect a single cell from being change in excell

G

Gord Dibben

Select all cells and Format>Cells>Protection.

Clear the "Locked" option and OK

Select a single cell and enable the "locked" on that cell.

Now Tools>Protection>Protect sheet.


Gord Dibben MS Excel MVP
 

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

Protecting Word 2019 document 0
Update several ppt documents from a single excel file 0
Password protect new workbooks from template 0
Possible to Combine reports to's to a single box? 0
Tracked changes by multiple people modified to one 0
Merging from an Excel file with graphics 1
Protection of cells in a worksheet 2
Mis-performing MP4 files in Mac PPT 1

Top