Solved

MS Excell cell protectect

Posted on 2011-09-07
4
250 Views
Last Modified: 2012-05-12
I am the only user of my spreadsheets. Sometimes I would like to protect a few cells that almost never change so I don't modify them by accident.

Is there a quick way to protect a few select cells?

Thanks
0
Comment
Question by:Ronnie Kaufman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 50 total points
ID: 36497566
By default, if you right click on any cell and check Format Cells-Protection, you will see that all are marked as "Protected". You need to uncheck this propertie on the cells that you want to write and then protect the sheet on Review-Protect Sheet so that the locking works.

jppinto
0
 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 50 total points
ID: 36497577
Here's a simple article about this:

http://support.microsoft.com/kb/214081

jppinto
0
 
LVL 17

Accepted Solution

by:
gtgloner earned 25 total points
ID: 36497588
Select all cells, right click and select Protection tab. Unselect the "Locked" checkbox and click OK. Select the cells you want protected and click Tools-Protection-Protect Sheet. Unselect "Select Locked Cells" checkbox and click OK.
0
 

Author Closing Comment

by:Ronnie Kaufman
ID: 36497654
Thanks to the 3 answers I got ...they each were goo ... and easy.

Much appreciate the very quick response.

Makes the Expert Exchange service worthwhile to belong to.

rk
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question