Notice that in the preceding image, there are numbered buttons arranged in a row beside the column letters, and in a column above the row numbers. Clicking on one of these numbered buttons arranged in a row will expand the rows in the worksheet to provide a given level of detail. Clicking on one of the numbered buttons arranged in a column will expand the columns in a similar way.

 

The view of the data in the preceding image is provided by the buttons numbered 1. Clicking on the number 2 button will expand the worksheet to the second level of detail for the rows, columns, or both.

 

 

This is the same worksheet after both number 2 buttons have been clicked. The worksheet rows and column have been expanded to show another level of detail. You can now see rows with quarterly totals as well as yearly totals. You can also see columns with figures for Sales and total Expenses.

 

If you click on an expand button, marked with a (+), a specific section of the outlined worksheet corresponding to the button will be shown. Clicking the collapse (-) button will collapse the corresponding expanded section.

 

If you click the number 3 button for the rows and columns, all levels of detail will be expanded to expose all of the data, as shown in the original Figure1.

 

Remember that with outlines, only the data that is visible on your screen will be printed. This is a great way to print only the pertinent information from an expansive worksheet. You can expand and collapse the outlined worksheet with the numbered outline buttons, or with the expansion (+) and collapse (-) buttons to reveal the level of detail you want in your printed copy.