Protected cell

  • Thread starter Thread starter juanpablo
  • Start date Start date
J

juanpablo

Is it possible to protect just some cells and not the entire book?

JPG
 
By default all cells are protected but that only becomes active if you
protect the sheet. So to do what you want select all the cells on a sheet then

Format|Cells|protection
Remove the locked checkmark
Then
select the cells you want to lock and repeat the above steps but insert the
locked checkmark
Protect the sheet and your done.

Mike
 
That doesnt work, because it does not allow me to use the pivot table.

I have pivots that I want to be able to use, but two rows below the table
need to be protected.

JPG
 
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

Protect Cells 10
Excel Protection 2
Protect Only Certain Cells 2
Cell Protection? 2
PROTECTING CELLS 2
Enabling Autofilter and Sorting in a Protected Sheet 2
Method for protecting cells which still allows quick editing 2
When sharing, can I force an Excel document to open in a certain view? 0

Back
Top