CELL PROTECTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I protect a cell or group of cells (not a whole row or column)?
 
G I

When the worksheet is protected by Tools>Protection>Protect Sheet all cells
are, by default, locked.

To just lock/protect some, hit CRTL + A to select all cells.

Format>Cells>Protection. Uncheck "locked".

Now select the cell or group of cells you wish locked then
Format>Cells>Protection. Check "locked".

Now protect the worksheet.

Gord Dibben Excel MVP
 
You could download the third party tool: AddinTools Assist from
http://www.addintools.com. It will temporarily display unlocked cells and
locked cells with different background colors. You will find out which are
locked cells, which are unlocked cells immediately. The "To Lock" button and
"To Unlock" button could lock or unlock the selected cell immediately. In
this way, you can decide fast which part of spreadsheet allows changing, and
which part disallows.
The function is very useful when you have forgotten which cells are locked
in a workbook or sheet.
 
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

Sheet Protection 3
Can't use protection options 1
Protect cells but allow for user input. 3
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Method for protecting cells which still allows quick editing 2
Protecting cell formulas in excel 2007 1
I can only delete an entire row not a cell in excel 2013? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top