O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Protecting Data

WORKBOOKS ARE MADE to be shared, and thus, Excel provides lots of ways in which you can easily do that. For example, you can share a workbook and track the individual changes everyone makes to it. You can later review those changes and accept or reject them as you want. See Chapter 14, “Collaborating with Others,” for help. Another way that you can protect data is to simply lock it down, preventing anyone from changing it. You can lock down individual cells, a range of cells, or an entire worksheet in order to prevent anyone from changing its data. You can also protect a whole workbook, in order to prevent changes to its structure, such as adding worksheets or changing the workbook window’s size. Finally, when needed, you can ...

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