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

Hiding Data

IF YOUR WORKBOOK CONTAINS private company data or confidential information, you do not need to show it if you don’t want to—you can hide it instead. In addition, if a workbook contains data that simply supports the main data, there’s no need to bore people with it—hide it from view so the workbook’s most important data remains the focus. In Chapter 6, “Managing Large Amounts of Excel Data,” you learned how to hide rows and columns, and even a single cell’s data. In this section, you learn how to hide an entire worksheet or workbook.

Tip

Hiding data does not prevent it from being seen by prying eyes. You must protect the worksheet or workbook to prevent users from simply redisplaying them. See the section “Protecting Data” for help. ...

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