From the course: Excel Essential Training (Microsoft 365)
Join today to access over 24,900 courses taught by industry experts.
Protecting worksheets and workbooks - Microsoft Excel Tutorial
From the course: Excel Essential Training (Microsoft 365)
Protecting worksheets and workbooks
- [Instructor] Excel has a number of protection techniques. In a simple example, if I have another associate who works with this file from time to time who primarily just makes minor changes and looks at the data, if I don't want that person seeing the rating column, I'll simply right click column H and hide the column. And if that person doesn't know how to use Excel that much and hasn't used it often knows nothing about hidden columns or anything, good enough. But sometimes we need more comprehensive schemes. Let me undo that. I'll press Ctrl + Z. What if we've got a situation where we want to hide column H, let nobody see it. We want the salaries to be visible, but we don't want any changes made to them. And the same thing with what's happening over in column F. These are formulas calculating years based on higher dates. We don't want anybody touching the data here. So let's begin with this idea. If you right click any cell in Excel and go to format cells and go to the protection…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.