Excel 2016 All-in-One For Dummies

Chapter 1

Protecting Workbooks and Worksheet Data

In This Chapter

Assigning a password for opening a workbook

Assigning a password for making editing changes in a workbook

Using the Locked and Hidden protection formats

Protecting a worksheet and selecting what actions are allowed

Enabling cell range editing by particular users in a protected sheet

Protecting the structure of a workbook

Protecting and sharing a workbook

Before you start sending out your spreadsheets for review (especially out of house), you need to make them secure. Security in Excel exists on two levels. The first is protecting the workbook file so that only people entrusted with the password can open the file to view, print, or edit the data. The second is protecting the worksheets in a workbook from unwarranted ...