Chapter 1

Protecting Workbooks and Worksheet Data


check Assigning a password for opening a workbook

check Assigning a password for making editing changes in a workbook

check Using the Locked and Hidden protection formats

check Protecting a worksheet and selecting what actions are allowed

check Enabling cell range editing by particular users in a protected sheet

check Doing data entry solely in unlocked cells of a protected worksheet

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