How to unprocted certain cell

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

Hi,

I've protected the whole sheet but I need some of the cell in the sheet to
be unprotected. How can I go about?

Regards,
 
Hi Kim,
Unprotect the sheet, highlight the cell you want to be unprotected, right
click in the mouse, format cells, last tab is protection, uncheck the box
that says locked, protect again the sheet
 
UNlock the cells in question before protecting the sheet. (Format Cells
Protection UNcheck "Locked")
 
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

Code to format cells on several worksheets 2
Using Bullets 3
Excel - unprotect certain cells in protected sheet/workbook 3
Protect Cells 10
Unprotect Combo Box in a Protected Sheet 3
procted and unprocted Template 1
Can I protect data in a cell, but allow comments to be entered. 6
Can't move between cells. (Not the scroll lock) 1

Back
Top