An outline is a version of your worksheet data that is useful for viewing the main "levels" of your data and further developing them. You can collapse and expand the levels of your sheet to display a condensed version of your data depending on your viewing needs. Use the following articles to learn how to navigate and format your worksheet as an outline.

Tips, Tricks, and Answers

The following articles are available for the 'Outlining' topic. Click the article''s title (shown in bold) to see the associated article.

   Hiding Outline Symbols
Outline symbols are automatically displayed by Excel when you add subtotals or organize your data using an outline. If you don't want those symbols to appear, you can configure Excel as described in this tip.

   Understanding Outlining
Outlining, a feature built into Excel, can be a great way to help organize large amounts of data. This tip provides an overview to the feature, focusing on different ways you can create your outline.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.