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