Tip Printed from ExcelTip.com

---

Copying or Applying Color to Groups and Outlines


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.