Ungroup outline data : Outline « Data Analysis « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Data Analysis
3. Outline

Select the data group. 
           Click the Data tab and click the Ungroup button arrow, and then click Ungroup.

Click the Rows or Columns option, and then click OK.

10.3.Outline
	10.3.1.	Create an Outline
	10.3.2.	Ungroup outline data
	10.3.3.	Clear an outline