how to lock a single cell?

  • Thread starter Thread starter has ex
  • Start date Start date
Hi
As default, all cells are locked - but the sheet is unprotected. Hit Ctrl+A
to select all cells and then from Format/Cells/Protection, uncheck Locked.
Now all of your cells are unlocked. Select the cell/s you wish to lock and
Format/Cells/Protection select Locked. To activate this, you now need to
protect the worksheet, from Tools/Protection/Protect Worksheet
 
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

Possible to select a string in a locked cell? 1
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Cell Protection not Working 3
JSON to CSV Conversion Gone Wrong: Got a Single Line of 991 Entrieswith Cells In Between. How Do I F 13
Can't change the cell back to blank when there is a date in it. 0
Protect locked cells (only) from formatting? 4
Lock Cells with Hyperlink 3

Back
Top