Excel - locking cells

J

JE McGimpsey

Locking doesn't work until the worksheet is protected. OTOH, you can
simply unlock all the cells except for the one you want to be locked,
then protect the worksheet.
 
S

Shane Devenshire

Hi,

Excel 2003:

1. Select the entire sheet
2. Choose Format, Cells, Protection, and uncheck Locked
3. Select the cell or cells you want locked and choose Format, Cells,
Protection and check Locked.
4. Choose Tools, Protection, Protect Sheet.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Place picture in Excel cell 0
need help ASAP word 2016 recipient cant edit 0
Excel --> Word 4
Merging from an Excel file with graphics 1
Lost Mouse 1
Word macro that can call cells out of Excel for a find and replace 0
Table of content - format does not get saved 2

Top