Thread: How do I protect individual cells in Excel and not whole sheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I protect individual cells in Excel and not whole sheet?
"Angus" wrote:
I need to protect individual cells on an Excel worksheet but not the whole
sheet. How can I do this?

Try this sequence:

Press Ctrl + A to select the entire sheet
Click Format Cells Protection tab
Uncheck "Locked"
Click OK

(By default all cells are set to locked)

Then hold down CTRL & select the cells you want to protect
Click Format Cells Protection tab
Check "Locked"
Click OK

Now, after you effect sheet protection via:
Clicking Tools Protect Protect Sheet passwrd? (optional) OK
the selected cells would be the only souls protected

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote