No data is deleted when you remove an outline.

1. Click the worksheet.
2. On the Data menu, point to Group and Outline, and then click Clear Outline.
3. If rows or columns are still hidden, drag across the visible row or column headings on both sides of the hidden rows and columns, point to Row or Column on the Format menu, and then click Unhide.

Notes

• You can also ungroup sections of the outline without removing the entire outline. Hold down SHIFT while you click the or for the group, then point to Group and Outline on the Data menu and click Ungroup.
• To hide the outline without removing it, display all of the data by clicking the highest number in the outline symbols, click Options on the Tools menu, click the View tab, and then clear the Outline symbols check box.