Hiding Outline Symbols

Once you go through the process of outlining your data, you may want to hide the outline symbols that Excel normally displays at the left of the worksheet area. These symbols are helpful as you are working with the data, by may be distracting if you are presenting the data to others. To turn off the symbols, follow these steps if you are using a version of Excel prior to Excel 2007:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the View tab is selected. (Click here to see a related figure.)
3. Clear the Outline Symbols check box.
4. Click on OK.

If you are using Excel 2007, then the steps are a bit different:

1. Click the Office button and then click Excel Options. The Excel Options dialog box appears.
2. Click Advanced at the left side of the dialog box.
3. Scroll through the available options until you get to the Display Options for This Worksheet group. (Click here to see a related figure.)
4. Clear the Show Outline Symbols if an Outline is Applied check box.
5. Click on OK.

To again display the symbols, follow the same steps, but make sure the Outline Symbols check box is selected.