From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Protect and validate

Protect and validate - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Protect and validate

“

- [Instructor] We've got this form where people are going to be putting scores in and they are going to be selecting people that they're scoring. We need to protect and control those inputs. We also have a complex formula in the background that calculates the scores. So let's say we want to go over here and we want to pick L-02. That's Avi. Score five, four, five, three, four. 'Kay. That calculates out to an 87. That's calculated over here. I'm going to highlight here. Right-click and hide. That's what's driving everything. Our objective. Limit the scores in column G to one, two, three, four or five. We shouldn't be able to put in a 3.5 or an eight or an S. We want to re-hide the background data. Then protect the sheet so that people can only change the gray cells. They shouldn't be able to type in a new name in C2 or readjust the score in C5. But in the protection, also make sure that people cannot even…

Contents