Outlining Data in Excel 2010

In this article I am going to explain outline in Excel 2010
  • 2868

Outlining Data in Excel 2010

Outlining Data is a properties in the Excel by which we create large amount of data in the group and we can show and hide to data from view. We can also summarize data for quick analysis using subtotal command.

To create Outlining Data we have to follow following steps.

Step 1

Open worksheet and sort to Data according to need .

After its select to all data.

Ottline1.jpg

Step 2

On Data tab in Outline group click on Subtotal.

outline2.jpg

Step 3

Then a Subtotal dialog box will be open.

Outline3.jpg

Step 4

In Subtotal dialog box choose function that are available for Subtotaling and select column on which we want to create group.

Outline4.jpg

Step 5

And click on ok Subtotal group will be created.

Outline5.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.