» Copying or Applying Color to Groups and Outlines

CATEGORY - Excel Grouping and Outlining VERSION - All Microsoft Excel Versions

To copy or apply colors to summary totals:

1. Create the summary report using Group and Outline.
2. Select any cell in the List, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the List.
3. Press Alt+; to select the visible cells.
4. Copy and paste the data into a different sheet.
OR
Apply color to the visible cells by selecting a color from the Fill Color icon on the Formatting toolbar.
Screenshot // Copying or Applying Color to Groups and Outlines