How do I lock only the cells that I want in Excel?

As a virtual assistant company working with Excel sheets is something we do on a regular basis. So when one of our readers emailed us and asked this question. We wanted to share our response with you as well. 

She had a worksheet that had a set of cells with information that it was vitally important did not get changed, and because the worksheet had to be shared with her entire team she wanted to make sure that no one accidentally edited that cell. However, she needed for the rest of the worksheet to remain editable. In situations like this for our readers we like to do these brief tips each month  to help you along and for our clients we often do brief video tutorials to make it easier for them figure out what they are doing. This month because of the nature of the questions being asked we thought it would easier to give you a video tutorial. 

So if you’d like to learn how to protect only one cell or a set of cells in Excel while allowing the rest of the worksheet to remain editable watch the video below.

We hope the video was helpful. Please leave us your comments below or get in touch today if you have any questions you’d like answered in an upcoming issue of our newsletter.

Print Friendly, PDF & Email
The following two tabs change content below.
Christian Mom of 2, animal lover, your virtual business partner helping you create success in your business, owner and CEO of Rhonda's Virtual Office and Partner of One Life ... Plan-It! discovering new passions in my business everyday and loving it!

Latest posts by Rhonda Holscher (see all)


We would love to hear from you. Please leave your comments below.