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 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 ...
Get Excel 2019 All-in-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.