How to Set Workbook Permissions in MicrosExcel 2013


show more Setting workbook permissions provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 signatu...

Setting workbook permissions
Video duration: 6m 44s 6h 21m Beginner

Viewers:

Setting workbook permissions provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...