From the course: Excel 2010 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Setting workbook permissions - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Setting workbook permissions
When you create a file for others to use, you might want to make sure that they can modify only certain cells like for a data entry, but not other cells like formulas and descriptive text. You also might want to require a password for even opening or modifying the workbook. These are some of the more common permission features. Let's have a look at what we can do. Click the File tab and go into the Info section if you're not there already, and here under Permissions, this is where it all happens. So, click Protect Workbook. And we can mark a workbook as final. We'll do that a little bit later. You can encrypt with a password so that only those who have the password can open the document. You can protect the current sheet, which means what we were just talking about that you can edit only parts of the sheet and not other parts of the sheet. Protecting Workbook Structure means that you can add, change or otherwise modify the worksheets of the workbook. And adding a digital signature is…
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.