Excel 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

Doing data entry solely in unlocked cells of a protected worksheet

Protecting the workbook

Before you start sending your worksheets for review, 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 changes so that ...