Copying or Applying Color to Groups and Outlines in Microsoft Excel 2010

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:-

Open in-built marketing budget plan in Excel workbook.
Go to File tab, and Click on New.
New window will appear.
Click on Budget in Suggested Searches.

Search Marketing Budget plan.
Choose any one template.

Management budget plan’s Excel file will get open.
Select the whole page of Excel’s sheet.

Go to Data Tab, and click on Auto outline group in the outline group.

We can see that every group will be created as per the row, as per the column, and as per the header as well.

To create the group, follow below given steps:-

Select the data range where you want to make the group.

to Data tab and click on group from the Outline group.

Group will get inserted. When you will click on level, selected data will get hide, and to show the data again click on 2.

To copy or apply color to group and outlines, follow below given steps:-

Click on level 2.
Select any cell in the report, and click level 1, and then press Ctrl+Shift+* to select the report.
Press Alt+; to select the visible cells.

Copy and paste the report into a different cell or apply the color to visible cells by selecting the color from Home Tab > Fill Color from the font group.

This is the way we can copy or apply color to groups and outlines in Microsoft Excel.