From the course: Excel 2019 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Protecting worksheets and workbooks

Protecting worksheets and workbooks

From the course: Excel 2019 Essential Training

Start my 1-month free trial

Protecting worksheets and workbooks

- [Instructor] Excel has two major protection features. They're found on the Review tab in the Ribbon. One, Protect Sheet, protect the current worksheet. One called Protect Workbook. The first one is a bit more powerful. It has to do with the content of a worksheet. In this worksheet here, imagine, you're in charge of this file, you have some trusted assistants who, from time to time, are gonna do the editing and making changes here. You've got a list of changes. A few things you're concerned about. You don't want anybody typing over the formulas that are in column E. Now they will change automatically, if the column D data changes, but we wanna protect these cells here. Similarly, that Salary data, you don't want any changes being made there. The Job Rating is even more sensitive, perhaps, than the Salary. We don't want that there either. Now we might consider hiding the column, but the whole protection scheme begins with this idea. Any cell in an Excel Worksheet, unless you've…

Contents