O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1: Protecting Workbooks and Worksheet Data

In This Chapter

arrow.png Assigning a password to open a workbook

arrow.png Assigning a password to make changes in a workbook

arrow.png Using the Locked and Hidden protection formats

arrow.png Protecting a worksheet and selecting what actions are allowed

arrow.png Enabling cell range editing by particular users in a protected sheet

arrow.png Protecting a workbook

arrow.png 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 changes so that only people entrusted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required