Microsoft® Office Excel® 2007 Plain & Simple

Outlining to Hide and Show Rows and Columns

When you develop worksheets, you’ll probably try to keep similar entries together. For example, if you create a worksheet that lists all of the products you sell, you can group the products by category. In the case of a garden supply store, all of the tools would be together, then the furniture, and then a new category for each type of plant. If you want to hide the rows for one set of products, you can define the rows as a group, and you’ll then have the option to choose which rows you would like displayed. The rows you hide are only gone temporarily. The data hasn’t been deleted, it’s just been moved out of your way while you don’t need it.

Group Rows and Columns

1. Select the rows or columns ...