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.