How to Create Outlining Data in Excel ?

  Excel Interview Q&A

Today we read on this page – how to create outlining data in Excel?

Outlining data makes it easy to see your data. In this example we will add rows of related data and collapse a set of columns.

Download the data excel file

First, sort the data on the company column –> On the Data tab, in the Outline group, click Subtotal –>  Select the company column, the column we use to outline our worksheet  –> Use the calculation function –> Check the company check box –> Click OK.

Following the steps which is given in snapshot

Outlining Data in excel data

Outlining Data in Excel

To collapse a group of cells, click on a minus sign. You can use numbers to drop or expand groups by level. For example, click 2 to show only subtotals.

To collapse a group of columns, perform the following steps

For example, choose columns A and B  –>  On the Data tab, in the Outline group, click Group  –> Click on the minus sign above column C (it will change to a plus sign)  –> To remove the outline, inside the data group and on the Data tab, click any cell in the Outline group, click Subtotal, Remove All.

Following the steps which is given in snapshot

Outlining Data in Excel

Outlining Data in Excel

LEAVE A COMMENT