Protecting Cells

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

Guest

I want to protect a few cells in a worksheet - not the whole worksheet. How
do I do it?
 
Sorry, you have to protect the whole worksheet, then UNprotect all of the
cells except those that you wish to secure. Alternative may be to provide
data validation on the cells that you wish to protect, but this is not
particularly secure (copy/paste will override, for example). For that
matter, nothing is secure, I guess.
 
Hi
first select the other cells, goto 'Format - Cells -
Protection' and unchek 'Locked'. After this protect the
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

How to change format protection default to unlocked? 2
Password Protect Specific Range Of Cells 6
Enabling Autofilter and Sorting in a Protected Sheet 2
Cell Protection? 2
Protected Worksheets with info that needs to be deleted. 5
protect worksheet 3
Protected Worksheet Tab Order 1
Protect Only Certain Cells 2

Back
Top