To group and summarize the data, we can create an outline up to eight levels in the data list. To expose the detail for each group, use an outline to display summary rows and columns quickly in Microsoft Excel 2010.
Outline: -An Outline helps in separating between top level and details. It is easy to create an Outline - using Auto Outline option in Microsoft Excel 2010.
Group: - This is used to create an outline or groups of rows and columns automatically.
You can use the shortcut Keys (Shift+Alt+ Right) or Alt>A>G>G.
To create the Outline, follow below given steps:-
To create the group, follow below given steps:-
to Data tab and click on group from the Outline group.
To copy or apply color to group and outlines, follow below given steps:-
This is the way we can copy or apply color to groups and outlines in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.