O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

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 and displaying information

In some cases, you might share your worksheet with folks who don’t need to see all the information it contains. Suppose, for example, that your worksheet includes the budget for your current project but you want to hide the information that shows how much you’re paying individual contractors. You can choose to hide columns or rows that include sensitive information you don’t want everyone to see. You can easily redisplay the rows or columns later when you want all data to be visible.

Hide columns or rows

  1. Select the rows or columns that you want to hide.

  2. Right-click and hold the selection, and then in the options menu or minibar that appears, click Hide.

Reveal hidden columns or rows

  1. Select the ...

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